<cfcomponent displayname="AgenciesDAO" hint="table ID column = id">	<cffunction name="init" access="public" output="false" returntype="AgenciesDAO">		<cfargument name="dsn" type="string" required="true">		<cfset variables.dsn = arguments.dsn>		<cfreturn this>	</cffunction>		<cffunction name="create" access="public" output="false" returntype="struct">		<cfargument name="Agencies" type="Agencies" required="true" />		<cfset var result = StructNew() />        <cfset var returnid = "" />		<cfset var qCreate = "" />		<cftry>			<cfquery name="qCreate" datasource="#variables.dsn#" result="returnid">				INSERT INTO agencies					(					name,					address1,					address2,					city,					state,					zipCode,					location,					phone,					fax,					website,					acceptUGJunior,					acceptUGSenior,					acceptFirstYear,					acceptSecondYear,					totalStudents,					agencyPractice,					servicesProvided,					theoryBase,					macroArea,					clinicalArea,					other,					stipend,					forProfit,					clinical,					foundation,					macro,					combined,					health,					metro,					carLicense,					foriegnLanguage,					flexTime,					handicapAccessible,					faithBased,					affiliationAgreement,					fwsAgreement,					agencyProfile,					multipleSites,					dateNinetyNine,					datePhoneInformationReceived,					dateOfAffiliation,					dateOfVisit,					backgroundDrugScreening,					backgroundChildAbuse,					backgroundImmunizationVerification,					backgroundLiabilityVerification,					backgroundSpecialApplication,					backgroundReferenceLetters,					backgroundFingerprinting,					backgroundPoliceClearance,					backgroundTBScreen,					backgroundOther,					backgroundRequiredDays,					ageGroupAdults,					ageGroupOlderAdults,					ageGroupAdolescents,					ageGroupFamilies,					ageGroupChildren0to5,					ageGroupChildren6to12,					comments,					needsLongForm,					currentlyActive,					doNotUse,					agencyFlag,					typeOfSetting,					privateComments,					leAdministration,					leAdvocacy,					leCaseManagement,					leClinicalCaseManagement,					leCommOrganization,					leCrisisIntervention,					leDischargePlanning,					leFamilyTreatment,					leGroupTreatment,					leIndWithAdult,					leIndWithChildren,					leIndWithAdolescents,					lePolicyAnalysis,					leProgramPlanning,					leProgramManagement,					leResearch,					leOther1,					leOther2,					tbCogBehavioral,					tbCommTheory,					tbCommDevelopment,					tbContingency,					tbCrisis,					tbEcological,					tbEmpowerment,					tbExchange,					tbFamilyTherapy,					tbFeminist,					tbPowerDependence,					tbPsychodynamic,					tbPsychosocial,					tbSolution,					tbSystems,					tbTranspersonal,					lobbying,					nonProfit,					agencyPublic,					agencyPrivate,					federal,					stateCounty,					communityBased,					undergraduateJunior,					ataother,					adultsRank,					olderAdultsRank,					adolescentsRank,					familiesRank,					children0to5Rank,					children6to12Rank,					multiple,					isPrivate,					isPublic,					completedDate,					completedName,					completedEmail,					undergraduateSenior,					transport,					backgroundMedicalExam,					tHomeVisits,					tDriversLicense,					tAutomobile,					tAgencyVehicle,					tOwnVehicle,					tCovered,					tOther,					mpPolicyAnalysis,					mpAdvocacy,					mpCommOrganization,					mpManagement,					mpAdministration,					mpPlanning,					mpEvalResearch,					comments2,					notSureYet,					flexHours,					leIndWithAdultAdd,					leIndWithChildrenAdd,					leIndWithAdolescentsAdd,					foreignLanguagePreferred					)				VALUES					(					<cfqueryparam value="#arguments.Agencies.getname()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getname())#" />,					<cfqueryparam value="#arguments.Agencies.getaddress1()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getaddress1())#" />,					<cfqueryparam value="#arguments.Agencies.getaddress2()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getaddress2())#" />,					<cfqueryparam value="#arguments.Agencies.getcity()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getcity())#" />,					<cfqueryparam value="#arguments.Agencies.getstate()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getstate())#" />,					<cfqueryparam value="#arguments.Agencies.getzipCode()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getzipCode())#" />,					<cfqueryparam value="#arguments.Agencies.getlocation()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getlocation())#" />,					<cfqueryparam value="#arguments.Agencies.getphone()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getphone())#" />,					<cfqueryparam value="#arguments.Agencies.getfax()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getfax())#" />,					<cfqueryparam value="#arguments.Agencies.getwebsite()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getwebsite())#" />,					<cfqueryparam value="#arguments.Agencies.getacceptUGJunior()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getacceptUGJunior())#" />,					<cfqueryparam value="#arguments.Agencies.getacceptUGSenior()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getacceptUGSenior())#" />,					<cfqueryparam value="#arguments.Agencies.getacceptFirstYear()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getacceptFirstYear())#" />,					<cfqueryparam value="#arguments.Agencies.getacceptSecondYear()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getacceptSecondYear())#" />,					<cfqueryparam value="#arguments.Agencies.gettotalStudents()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.gettotalStudents())#" />,					<cfqueryparam value="#arguments.Agencies.getagencyPractice()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getagencyPractice())#" />,					<cfqueryparam value="#arguments.Agencies.getservicesProvided()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getservicesProvided())#" />,					<cfqueryparam value="#arguments.Agencies.gettheoryBase()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.gettheoryBase())#" />,					<cfqueryparam value="#arguments.Agencies.getmacroArea()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getmacroArea())#" />,					<cfqueryparam value="#arguments.Agencies.getclinicalArea()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getclinicalArea())#" />,					<cfqueryparam value="#arguments.Agencies.getother()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getother())#" />,					<cfqueryparam value="#arguments.Agencies.getstipend()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getstipend())#" />,					<cfqueryparam value="#arguments.Agencies.getforProfit()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getforProfit())#" />,					<cfqueryparam value="#arguments.Agencies.getclinical()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getclinical())#" />,					<cfqueryparam value="#arguments.Agencies.getfoundation()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getfoundation())#" />,					<cfqueryparam value="#arguments.Agencies.getmacro()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getmacro())#" />,					<cfqueryparam value="#arguments.Agencies.getcombined()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getcombined())#" />,					<cfqueryparam value="#arguments.Agencies.gethealth()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gethealth())#" />,					<cfqueryparam value="#arguments.Agencies.getmetro()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getmetro())#" />,					<cfqueryparam value="#arguments.Agencies.getcarLicense()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getcarLicense())#" />,					<cfqueryparam value="#arguments.Agencies.getforiegnLanguage()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getforiegnLanguage())#" />,					<cfqueryparam value="#arguments.Agencies.getflexTime()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getflexTime())#" />,					<cfqueryparam value="#arguments.Agencies.gethandicapAccessible()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gethandicapAccessible())#" />,					<cfqueryparam value="#arguments.Agencies.getfaithBased()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getfaithBased())#" />,					<cfqueryparam value="#arguments.Agencies.getaffiliationAgreement()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getaffiliationAgreement())#" />,					<cfqueryparam value="#arguments.Agencies.getfwsAgreement()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getfwsAgreement())#" />,					<cfqueryparam value="#arguments.Agencies.getagencyProfile()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getagencyProfile())#" />,					<cfqueryparam value="#arguments.Agencies.getmultipleSites()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getmultipleSites())#" />,					<cfqueryparam value="#arguments.Agencies.getdateNinetyNine()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getdateNinetyNine())#" />,					<cfqueryparam value="#arguments.Agencies.getdatePhoneInformationReceived()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getdatePhoneInformationReceived())#" />,					<cfqueryparam value="#arguments.Agencies.getdateOfAffiliation()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getdateOfAffiliation())#" />,					<cfqueryparam value="#arguments.Agencies.getdateOfVisit()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getdateOfVisit())#" />,					<cfqueryparam value="#arguments.Agencies.getbackgroundDrugScreening()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundDrugScreening())#" />,					<cfqueryparam value="#arguments.Agencies.getbackgroundChildAbuse()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundChildAbuse())#" />,					<cfqueryparam value="#arguments.Agencies.getbackgroundImmunizationVerification()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundImmunizationVerification())#" />,					<cfqueryparam value="#arguments.Agencies.getbackgroundLiabilityVerification()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundLiabilityVerification())#" />,					<cfqueryparam value="#arguments.Agencies.getbackgroundSpecialApplication()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundSpecialApplication())#" />,					<cfqueryparam value="#arguments.Agencies.getbackgroundReferenceLetters()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundReferenceLetters())#" />,					<cfqueryparam value="#arguments.Agencies.getbackgroundFingerprinting()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundFingerprinting())#" />,					<cfqueryparam value="#arguments.Agencies.getbackgroundPoliceClearance()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundPoliceClearance())#" />,					<cfqueryparam value="#arguments.Agencies.getbackgroundTBScreen()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundTBScreen())#" />,					<cfqueryparam value="#arguments.Agencies.getbackgroundOther()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getbackgroundOther())#" />,					<cfqueryparam value="#arguments.Agencies.getbackgroundRequiredDays()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getbackgroundRequiredDays())#" />,					<cfqueryparam value="#arguments.Agencies.getageGroupAdults()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupAdults())#" />,					<cfqueryparam value="#arguments.Agencies.getageGroupOlderAdults()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupOlderAdults())#" />,					<cfqueryparam value="#arguments.Agencies.getageGroupAdolescents()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupAdolescents())#" />,					<cfqueryparam value="#arguments.Agencies.getageGroupFamilies()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupFamilies())#" />,					<cfqueryparam value="#arguments.Agencies.getageGroupChildren0to5()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupChildren0to5())#" />,					<cfqueryparam value="#arguments.Agencies.getageGroupChildren6to12()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupChildren6to12())#" />,					<cfqueryparam value="#arguments.Agencies.getcomments()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getcomments())#" />,					<cfqueryparam value="#arguments.Agencies.getneedsLongForm()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getneedsLongForm())#" />,					<cfqueryparam value="#arguments.Agencies.getcurrentlyActive()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getcurrentlyActive())#" />,					<cfqueryparam value="#arguments.Agencies.getdoNotUse()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getdoNotUse())#" />,					<cfqueryparam value="#arguments.Agencies.getagencyFlag()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getagencyFlag())#" />,					<cfqueryparam value="#arguments.Agencies.gettypeOfSetting()#" CFSQLType="cf_sql_char" null="#not len(arguments.Agencies.gettypeOfSetting())#" />,					<cfqueryparam value="#arguments.Agencies.getprivateComments()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getprivateComments())#" />,					<cfqueryparam value="#arguments.Agencies.getleAdministration()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleAdministration())#" />,					<cfqueryparam value="#arguments.Agencies.getleAdvocacy()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleAdvocacy())#" />,					<cfqueryparam value="#arguments.Agencies.getleCaseManagement()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleCaseManagement())#" />,					<cfqueryparam value="#arguments.Agencies.getleClinicalCaseManagement()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleClinicalCaseManagement())#" />,					<cfqueryparam value="#arguments.Agencies.getleCommOrganization()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleCommOrganization())#" />,					<cfqueryparam value="#arguments.Agencies.getleCrisisIntervention()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleCrisisIntervention())#" />,					<cfqueryparam value="#arguments.Agencies.getleDischargePlanning()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleDischargePlanning())#" />,					<cfqueryparam value="#arguments.Agencies.getleFamilyTreatment()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleFamilyTreatment())#" />,					<cfqueryparam value="#arguments.Agencies.getleGroupTreatment()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleGroupTreatment())#" />,					<cfqueryparam value="#arguments.Agencies.getleIndWithAdult()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleIndWithAdult())#" />,					<cfqueryparam value="#arguments.Agencies.getleIndWithChildren()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleIndWithChildren())#" />,					<cfqueryparam value="#arguments.Agencies.getleIndWithAdolescents()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleIndWithAdolescents())#" />,					<cfqueryparam value="#arguments.Agencies.getlePolicyAnalysis()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getlePolicyAnalysis())#" />,					<cfqueryparam value="#arguments.Agencies.getleProgramPlanning()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleProgramPlanning())#" />,					<cfqueryparam value="#arguments.Agencies.getleProgramManagement()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleProgramManagement())#" />,					<cfqueryparam value="#arguments.Agencies.getleResearch()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleResearch())#" />,					<cfqueryparam value="#arguments.Agencies.getleOther1()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleOther1())#" />,					<cfqueryparam value="#arguments.Agencies.getleOther2()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleOther2())#" />,					<cfqueryparam value="#arguments.Agencies.gettbCogBehavioral()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbCogBehavioral())#" />,					<cfqueryparam value="#arguments.Agencies.gettbCommTheory()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbCommTheory())#" />,					<cfqueryparam value="#arguments.Agencies.gettbCommDevelopment()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbCommDevelopment())#" />,					<cfqueryparam value="#arguments.Agencies.gettbContingency()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbContingency())#" />,					<cfqueryparam value="#arguments.Agencies.gettbCrisis()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbCrisis())#" />,					<cfqueryparam value="#arguments.Agencies.gettbEcological()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbEcological())#" />,					<cfqueryparam value="#arguments.Agencies.gettbEmpowerment()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbEmpowerment())#" />,					<cfqueryparam value="#arguments.Agencies.gettbExchange()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbExchange())#" />,					<cfqueryparam value="#arguments.Agencies.gettbFamilyTherapy()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbFamilyTherapy())#" />,					<cfqueryparam value="#arguments.Agencies.gettbFeminist()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbFeminist())#" />,					<cfqueryparam value="#arguments.Agencies.gettbPowerDependence()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbPowerDependence())#" />,					<cfqueryparam value="#arguments.Agencies.gettbPsychodynamic()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbPsychodynamic())#" />,					<cfqueryparam value="#arguments.Agencies.gettbPsychosocial()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbPsychosocial())#" />,					<cfqueryparam value="#arguments.Agencies.gettbSolution()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbSolution())#" />,					<cfqueryparam value="#arguments.Agencies.gettbSystems()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbSystems())#" />,					<cfqueryparam value="#arguments.Agencies.gettbTranspersonal()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbTranspersonal())#" />,					<cfqueryparam value="#arguments.Agencies.getlobbying()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getlobbying())#" />,					<cfqueryparam value="#arguments.Agencies.getnonProfit()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getnonProfit())#" />,					<cfqueryparam value="#arguments.Agencies.getagencyPublic()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getagencyPublic())#" />,					<cfqueryparam value="#arguments.Agencies.getagencyPrivate()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getagencyPrivate())#" />,					<cfqueryparam value="#arguments.Agencies.getfederal()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getfederal())#" />,					<cfqueryparam value="#arguments.Agencies.getstateCounty()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getstateCounty())#" />,					<cfqueryparam value="#arguments.Agencies.getcommunityBased()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getcommunityBased())#" />,					<cfqueryparam value="#arguments.Agencies.getundergraduateJunior()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getundergraduateJunior())#" />,					<cfqueryparam value="#arguments.Agencies.getataother()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getataother())#" />,					<cfqueryparam value="#arguments.Agencies.getadultsRank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getadultsRank())#" />,					<cfqueryparam value="#arguments.Agencies.getolderAdultsRank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getolderAdultsRank())#" />,					<cfqueryparam value="#arguments.Agencies.getadolescentsRank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getadolescentsRank())#" />,					<cfqueryparam value="#arguments.Agencies.getfamiliesRank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getfamiliesRank())#" />,					<cfqueryparam value="#arguments.Agencies.getchildren0to5Rank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getchildren0to5Rank())#" />,					<cfqueryparam value="#arguments.Agencies.getchildren6to12Rank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getchildren6to12Rank())#" />,					<cfqueryparam value="#arguments.Agencies.getmultiple()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getmultiple())#" />,					<cfqueryparam value="#arguments.Agencies.getisPrivate()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getisPrivate())#" />,					<cfqueryparam value="#arguments.Agencies.getisPublic()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getisPublic())#" />,					<cfqueryparam value="#arguments.Agencies.getcompletedDate()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getcompletedDate())#" />,					<cfqueryparam value="#arguments.Agencies.getcompletedName()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getcompletedName())#" />,					<cfqueryparam value="#arguments.Agencies.getcompletedEmail()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getcompletedEmail())#" />,					<cfqueryparam value="#arguments.Agencies.getundergraduateSenior()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getundergraduateSenior())#" />,					<cfqueryparam value="#arguments.Agencies.gettransport()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettransport())#" />,					<cfqueryparam value="#arguments.Agencies.getbackgroundMedicalExam()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundMedicalExam())#" />,					<cfqueryparam value="#arguments.Agencies.gettHomeVisits()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettHomeVisits())#" />,					<cfqueryparam value="#arguments.Agencies.gettDriversLicense()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettDriversLicense())#" />,					<cfqueryparam value="#arguments.Agencies.gettAutomobile()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettAutomobile())#" />,					<cfqueryparam value="#arguments.Agencies.gettAgencyVehicle()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettAgencyVehicle())#" />,					<cfqueryparam value="#arguments.Agencies.gettOwnVehicle()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettOwnVehicle())#" />,					<cfqueryparam value="#arguments.Agencies.gettCovered()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettCovered())#" />,					<cfqueryparam value="#arguments.Agencies.gettOther()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.gettOther())#" />,					<cfqueryparam value="#arguments.Agencies.getmpPolicyAnalysis()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpPolicyAnalysis())#" />,					<cfqueryparam value="#arguments.Agencies.getmpAdvocacy()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpAdvocacy())#" />,					<cfqueryparam value="#arguments.Agencies.getmpCommOrganization()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpCommOrganization())#" />,					<cfqueryparam value="#arguments.Agencies.getmpManagement()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpManagement())#" />,					<cfqueryparam value="#arguments.Agencies.getmpAdministration()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpAdministration())#" />,					<cfqueryparam value="#arguments.Agencies.getmpPlanning()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpPlanning())#" />,					<cfqueryparam value="#arguments.Agencies.getmpEvalResearch()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpEvalResearch())#" />,					<cfqueryparam value="#arguments.Agencies.getcomments2()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getcomments2())#" />,					<cfqueryparam value="#arguments.Agencies.getnotSureYet()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getnotSureYet())#" />,					<cfqueryparam value="#arguments.Agencies.getflexHours()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getflexHours())#" />,					<cfqueryparam value="#arguments.Agencies.getleIndWithAdultAdd()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleIndWithAdultAdd())#" />,					<cfqueryparam value="#arguments.Agencies.getleIndWithChildrenAdd()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleIndWithChildrenAdd())#" />,					<cfqueryparam value="#arguments.Agencies.getleIndWithAdolescentsAdd()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleIndWithAdolescentsAdd())#" />,					<cfqueryparam value="#arguments.Agencies.getforeignLanguagePreferred()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getforeignLanguagePreferred())#" />					)			</cfquery>			<cfcatch type="database">            	<cfset result.success = false />                <cfset result.catch = cfcatch />                <cfset result.query = '                            INSERT INTO agencies                                (                                name,                                address1,                                address2,                                city,                                state,                                zipCode,                                location,                                phone,                                fax,                                website,                                acceptUGJunior,                                acceptUGSenior,                                acceptFirstYear,                                acceptSecondYear,                                totalStudents,                                agencyPractice,                                servicesProvided,                                theoryBase,                                macroArea,                                clinicalArea,                                other,                                stipend,                                forProfit,                                clinical,                                foundation,                                macro,                                combined,                                health,                                metro,                                carLicense,                                foriegnLanguage,                                flexTime,                                handicapAccessible,                                faithBased,                                affiliationAgreement,                                fwsAgreement,                                agencyProfile,                                multipleSites,                                dateNinetyNine,                                datePhoneInformationReceived,                                dateOfAffiliation,                                dateOfVisit,                                backgroundDrugScreening,                                backgroundChildAbuse,                                backgroundImmunizationVerification,                                backgroundLiabilityVerification,                                backgroundSpecialApplication,                                backgroundReferenceLetters,                                backgroundFingerprinting,                                backgroundPoliceClearance,                                backgroundTBScreen,                                backgroundOther,                                backgroundRequiredDays,                                ageGroupAdults,                                ageGroupOlderAdults,                                ageGroupAdolescents,                                ageGroupFamilies,                                ageGroupChildren0to5,                                ageGroupChildren6to12,                                comments,                                needsLongForm,                                currentlyActive,                                doNotUse,                                agencyFlag,                                typeOfSetting,                                privateComments,                                leAdministration,                                leAdvocacy,                                leCaseManagement,                                leClinicalCaseManagement,                                leCommOrganization,                                leCrisisIntervention,                                leDischargePlanning,                                leFamilyTreatment,                                leGroupTreatment,                                leIndWithAdult,                                leIndWithChildren,                                leIndWithAdolescents,                                lePolicyAnalysis,                                leProgramPlanning,                                leProgramManagement,                                leResearch,                                leOther1,                                leOther2,                                tbCogBehavioral,                                tbCommTheory,                                tbCommDevelopment,                                tbContingency,                                tbCrisis,                                tbEcological,                                tbEmpowerment,                                tbExchange,                                tbFamilyTherapy,                                tbFeminist,                                tbPowerDependence,                                tbPsychodynamic,                                tbPsychosocial,                                tbSolution,                                tbSystems,                                tbTranspersonal,                                lobbying,                                nonProfit,                                agencyPublic,                                agencyPrivate,                                federal,                                stateCounty,                                communityBased,                                undergraduateJunior,                                ataother,                                adultsRank,                                olderAdultsRank,                                adolescentsRank,                                familiesRank,                                children0to5Rank,                                children6to12Rank,                                multiple,                                isPrivate,                                isPublic,                                completedDate,                                completedName,                                completedEmail,                                undergraduateSenior,                                transport,                                backgroundMedicalExam,                                tHomeVisits,                                tDriversLicense,                                tAutomobile,                                tAgencyVehicle,                                tOwnVehicle,                                tCovered,                                tOther,                                mpPolicyAnalysis,                                mpAdvocacy,                                mpCommOrganization,                                mpManagement,                                mpAdministration,                                mpPlanning,                                mpEvalResearch,                                comments2,                                notSureYet,                                flexHours,                                leIndWithAdultAdd,                                leIndWithChildrenAdd,                                leIndWithAdolescentsAdd,                                foreignLanguagePreferred                                )                            VALUES                                (                                <cfqueryparam value="#arguments.Agencies.getname()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getname())#" />,                                <cfqueryparam value="#arguments.Agencies.getaddress1()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getaddress1())#" />,                                <cfqueryparam value="#arguments.Agencies.getaddress2()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getaddress2())#" />,                                <cfqueryparam value="#arguments.Agencies.getcity()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getcity())#" />,                                <cfqueryparam value="#arguments.Agencies.getstate()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getstate())#" />,                                <cfqueryparam value="#arguments.Agencies.getzipCode()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getzipCode())#" />,                                <cfqueryparam value="#arguments.Agencies.getlocation()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getlocation())#" />,                                <cfqueryparam value="#arguments.Agencies.getphone()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getphone())#" />,                                <cfqueryparam value="#arguments.Agencies.getfax()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getfax())#" />,                                <cfqueryparam value="#arguments.Agencies.getwebsite()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getwebsite())#" />,                                <cfqueryparam value="#arguments.Agencies.getacceptUGJunior()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getacceptUGJunior())#" />,                                <cfqueryparam value="#arguments.Agencies.getacceptUGSenior()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getacceptUGSenior())#" />,                                <cfqueryparam value="#arguments.Agencies.getacceptFirstYear()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getacceptFirstYear())#" />,                                <cfqueryparam value="#arguments.Agencies.getacceptSecondYear()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getacceptSecondYear())#" />,                                <cfqueryparam value="#arguments.Agencies.gettotalStudents()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.gettotalStudents())#" />,                                <cfqueryparam value="#arguments.Agencies.getagencyPractice()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getagencyPractice())#" />,                                <cfqueryparam value="#arguments.Agencies.getservicesProvided()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getservicesProvided())#" />,                                <cfqueryparam value="#arguments.Agencies.gettheoryBase()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.gettheoryBase())#" />,                                <cfqueryparam value="#arguments.Agencies.getmacroArea()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getmacroArea())#" />,                                <cfqueryparam value="#arguments.Agencies.getclinicalArea()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getclinicalArea())#" />,                                <cfqueryparam value="#arguments.Agencies.getother()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getother())#" />,                                <cfqueryparam value="#arguments.Agencies.getstipend()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getstipend())#" />,                                <cfqueryparam value="#arguments.Agencies.getforProfit()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getforProfit())#" />,                                <cfqueryparam value="#arguments.Agencies.getclinical()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getclinical())#" />,                                <cfqueryparam value="#arguments.Agencies.getfoundation()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getfoundation())#" />,                                <cfqueryparam value="#arguments.Agencies.getmacro()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getmacro())#" />,                                <cfqueryparam value="#arguments.Agencies.getcombined()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getcombined())#" />,                                <cfqueryparam value="#arguments.Agencies.gethealth()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gethealth())#" />,                                <cfqueryparam value="#arguments.Agencies.getmetro()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getmetro())#" />,                                <cfqueryparam value="#arguments.Agencies.getcarLicense()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getcarLicense())#" />,                                <cfqueryparam value="#arguments.Agencies.getforiegnLanguage()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getforiegnLanguage())#" />,                                <cfqueryparam value="#arguments.Agencies.getflexTime()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getflexTime())#" />,                                <cfqueryparam value="#arguments.Agencies.gethandicapAccessible()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gethandicapAccessible())#" />,                                <cfqueryparam value="#arguments.Agencies.getfaithBased()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getfaithBased())#" />,                                <cfqueryparam value="#arguments.Agencies.getaffiliationAgreement()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getaffiliationAgreement())#" />,                                <cfqueryparam value="#arguments.Agencies.getfwsAgreement()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getfwsAgreement())#" />,                                <cfqueryparam value="#arguments.Agencies.getagencyProfile()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getagencyProfile())#" />,                                <cfqueryparam value="#arguments.Agencies.getmultipleSites()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getmultipleSites())#" />,                                <cfqueryparam value="#arguments.Agencies.getdateNinetyNine()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getdateNinetyNine())#" />,                                <cfqueryparam value="#arguments.Agencies.getdatePhoneInformationReceived()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getdatePhoneInformationReceived())#" />,                                <cfqueryparam value="#arguments.Agencies.getdateOfAffiliation()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getdateOfAffiliation())#" />,                                <cfqueryparam value="#arguments.Agencies.getdateOfVisit()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getdateOfVisit())#" />,                                <cfqueryparam value="#arguments.Agencies.getbackgroundDrugScreening()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundDrugScreening())#" />,                                <cfqueryparam value="#arguments.Agencies.getbackgroundChildAbuse()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundChildAbuse())#" />,                                <cfqueryparam value="#arguments.Agencies.getbackgroundImmunizationVerification()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundImmunizationVerification())#" />,                                <cfqueryparam value="#arguments.Agencies.getbackgroundLiabilityVerification()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundLiabilityVerification())#" />,                                <cfqueryparam value="#arguments.Agencies.getbackgroundSpecialApplication()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundSpecialApplication())#" />,                                <cfqueryparam value="#arguments.Agencies.getbackgroundReferenceLetters()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundReferenceLetters())#" />,                                <cfqueryparam value="#arguments.Agencies.getbackgroundFingerprinting()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundFingerprinting())#" />,                                <cfqueryparam value="#arguments.Agencies.getbackgroundPoliceClearance()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundPoliceClearance())#" />,                                <cfqueryparam value="#arguments.Agencies.getbackgroundTBScreen()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundTBScreen())#" />,                                <cfqueryparam value="#arguments.Agencies.getbackgroundOther()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getbackgroundOther())#" />,                                <cfqueryparam value="#arguments.Agencies.getbackgroundRequiredDays()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getbackgroundRequiredDays())#" />,                                <cfqueryparam value="#arguments.Agencies.getageGroupAdults()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupAdults())#" />,                                <cfqueryparam value="#arguments.Agencies.getageGroupOlderAdults()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupOlderAdults())#" />,                                <cfqueryparam value="#arguments.Agencies.getageGroupAdolescents()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupAdolescents())#" />,                                <cfqueryparam value="#arguments.Agencies.getageGroupFamilies()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupFamilies())#" />,                                <cfqueryparam value="#arguments.Agencies.getageGroupChildren0to5()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupChildren0to5())#" />,                                <cfqueryparam value="#arguments.Agencies.getageGroupChildren6to12()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupChildren6to12())#" />,                                <cfqueryparam value="#arguments.Agencies.getcomments()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getcomments())#" />,                                <cfqueryparam value="#arguments.Agencies.getneedsLongForm()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getneedsLongForm())#" />,                                <cfqueryparam value="#arguments.Agencies.getcurrentlyActive()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getcurrentlyActive())#" />,                                <cfqueryparam value="#arguments.Agencies.getdoNotUse()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getdoNotUse())#" />,                                <cfqueryparam value="#arguments.Agencies.getagencyFlag()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getagencyFlag())#" />,                                <cfqueryparam value="#arguments.Agencies.gettypeOfSetting()#" CFSQLType="cf_sql_char" null="#not len(arguments.Agencies.gettypeOfSetting())#" />,                                <cfqueryparam value="#arguments.Agencies.getprivateComments()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getprivateComments())#" />,                                <cfqueryparam value="#arguments.Agencies.getleAdministration()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleAdministration())#" />,                                <cfqueryparam value="#arguments.Agencies.getleAdvocacy()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleAdvocacy())#" />,                                <cfqueryparam value="#arguments.Agencies.getleCaseManagement()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleCaseManagement())#" />,                                <cfqueryparam value="#arguments.Agencies.getleClinicalCaseManagement()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleClinicalCaseManagement())#" />,                                <cfqueryparam value="#arguments.Agencies.getleCommOrganization()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleCommOrganization())#" />,                                <cfqueryparam value="#arguments.Agencies.getleCrisisIntervention()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleCrisisIntervention())#" />,                                <cfqueryparam value="#arguments.Agencies.getleDischargePlanning()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleDischargePlanning())#" />,                                <cfqueryparam value="#arguments.Agencies.getleFamilyTreatment()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleFamilyTreatment())#" />,                                <cfqueryparam value="#arguments.Agencies.getleGroupTreatment()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleGroupTreatment())#" />,                                <cfqueryparam value="#arguments.Agencies.getleIndWithAdult()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleIndWithAdult())#" />,                                <cfqueryparam value="#arguments.Agencies.getleIndWithChildren()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleIndWithChildren())#" />,                                <cfqueryparam value="#arguments.Agencies.getleIndWithAdolescents()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleIndWithAdolescents())#" />,                                <cfqueryparam value="#arguments.Agencies.getlePolicyAnalysis()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getlePolicyAnalysis())#" />,                                <cfqueryparam value="#arguments.Agencies.getleProgramPlanning()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleProgramPlanning())#" />,                                <cfqueryparam value="#arguments.Agencies.getleProgramManagement()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleProgramManagement())#" />,                                <cfqueryparam value="#arguments.Agencies.getleResearch()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleResearch())#" />,                                <cfqueryparam value="#arguments.Agencies.getleOther1()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleOther1())#" />,                                <cfqueryparam value="#arguments.Agencies.getleOther2()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleOther2())#" />,                                <cfqueryparam value="#arguments.Agencies.gettbCogBehavioral()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbCogBehavioral())#" />,                                <cfqueryparam value="#arguments.Agencies.gettbCommTheory()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbCommTheory())#" />,                                <cfqueryparam value="#arguments.Agencies.gettbCommDevelopment()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbCommDevelopment())#" />,                                <cfqueryparam value="#arguments.Agencies.gettbContingency()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbContingency())#" />,                                <cfqueryparam value="#arguments.Agencies.gettbCrisis()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbCrisis())#" />,                                <cfqueryparam value="#arguments.Agencies.gettbEcological()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbEcological())#" />,                                <cfqueryparam value="#arguments.Agencies.gettbEmpowerment()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbEmpowerment())#" />,                                <cfqueryparam value="#arguments.Agencies.gettbExchange()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbExchange())#" />,                                <cfqueryparam value="#arguments.Agencies.gettbFamilyTherapy()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbFamilyTherapy())#" />,                                <cfqueryparam value="#arguments.Agencies.gettbFeminist()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbFeminist())#" />,                                <cfqueryparam value="#arguments.Agencies.gettbPowerDependence()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbPowerDependence())#" />,                                <cfqueryparam value="#arguments.Agencies.gettbPsychodynamic()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbPsychodynamic())#" />,                                <cfqueryparam value="#arguments.Agencies.gettbPsychosocial()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbPsychosocial())#" />,                                <cfqueryparam value="#arguments.Agencies.gettbSolution()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbSolution())#" />,                                <cfqueryparam value="#arguments.Agencies.gettbSystems()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbSystems())#" />,                                <cfqueryparam value="#arguments.Agencies.gettbTranspersonal()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbTranspersonal())#" />,                                <cfqueryparam value="#arguments.Agencies.getlobbying()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getlobbying())#" />,                                <cfqueryparam value="#arguments.Agencies.getnonProfit()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getnonProfit())#" />,                                <cfqueryparam value="#arguments.Agencies.getagencyPublic()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getagencyPublic())#" />,                                <cfqueryparam value="#arguments.Agencies.getagencyPrivate()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getagencyPrivate())#" />,                                <cfqueryparam value="#arguments.Agencies.getfederal()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getfederal())#" />,                                <cfqueryparam value="#arguments.Agencies.getstateCounty()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getstateCounty())#" />,                                <cfqueryparam value="#arguments.Agencies.getcommunityBased()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getcommunityBased())#" />,                                <cfqueryparam value="#arguments.Agencies.getundergraduateJunior()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getundergraduateJunior())#" />,                                <cfqueryparam value="#arguments.Agencies.getataother()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getataother())#" />,                                <cfqueryparam value="#arguments.Agencies.getadultsRank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getadultsRank())#" />,                                <cfqueryparam value="#arguments.Agencies.getolderAdultsRank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getolderAdultsRank())#" />,                                <cfqueryparam value="#arguments.Agencies.getadolescentsRank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getadolescentsRank())#" />,                                <cfqueryparam value="#arguments.Agencies.getfamiliesRank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getfamiliesRank())#" />,                                <cfqueryparam value="#arguments.Agencies.getchildren0to5Rank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getchildren0to5Rank())#" />,                                <cfqueryparam value="#arguments.Agencies.getchildren6to12Rank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getchildren6to12Rank())#" />,                                <cfqueryparam value="#arguments.Agencies.getmultiple()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getmultiple())#" />,                                <cfqueryparam value="#arguments.Agencies.getisPrivate()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getisPrivate())#" />,                                <cfqueryparam value="#arguments.Agencies.getisPublic()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getisPublic())#" />,                                <cfqueryparam value="#arguments.Agencies.getcompletedDate()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getcompletedDate())#" />,                                <cfqueryparam value="#arguments.Agencies.getcompletedName()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getcompletedName())#" />,                                <cfqueryparam value="#arguments.Agencies.getcompletedEmail()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getcompletedEmail())#" />,                                <cfqueryparam value="#arguments.Agencies.getundergraduateSenior()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getundergraduateSenior())#" />,                                <cfqueryparam value="#arguments.Agencies.gettransport()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettransport())#" />,                                <cfqueryparam value="#arguments.Agencies.getbackgroundMedicalExam()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundMedicalExam())#" />,                                <cfqueryparam value="#arguments.Agencies.gettHomeVisits()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettHomeVisits())#" />,                                <cfqueryparam value="#arguments.Agencies.gettDriversLicense()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettDriversLicense())#" />,                                <cfqueryparam value="#arguments.Agencies.gettAutomobile()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettAutomobile())#" />,                                <cfqueryparam value="#arguments.Agencies.gettAgencyVehicle()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettAgencyVehicle())#" />,                                <cfqueryparam value="#arguments.Agencies.gettOwnVehicle()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettOwnVehicle())#" />,                                <cfqueryparam value="#arguments.Agencies.gettCovered()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettCovered())#" />,                                <cfqueryparam value="#arguments.Agencies.gettOther()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.gettOther())#" />,                                <cfqueryparam value="#arguments.Agencies.getmpPolicyAnalysis()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpPolicyAnalysis())#" />,                                <cfqueryparam value="#arguments.Agencies.getmpAdvocacy()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpAdvocacy())#" />,                                <cfqueryparam value="#arguments.Agencies.getmpCommOrganization()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpCommOrganization())#" />,                                <cfqueryparam value="#arguments.Agencies.getmpManagement()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpManagement())#" />,                                <cfqueryparam value="#arguments.Agencies.getmpAdministration()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpAdministration())#" />,                                <cfqueryparam value="#arguments.Agencies.getmpPlanning()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpPlanning())#" />,                                <cfqueryparam value="#arguments.Agencies.getmpEvalResearch()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpEvalResearch())#" />,                                <cfqueryparam value="#arguments.Agencies.getcomments2()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getcomments2())#" />,                                <cfqueryparam value="#arguments.Agencies.getnotSureYet()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getnotSureYet())#" />,                                <cfqueryparam value="#arguments.Agencies.getflexHours()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getflexHours())#" />,                                <cfqueryparam value="#arguments.Agencies.getleIndWithAdultAdd()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleIndWithAdultAdd())#" />,                                <cfqueryparam value="#arguments.Agencies.getleIndWithChildrenAdd()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleIndWithChildrenAdd())#" />,                                <cfqueryparam value="#arguments.Agencies.getleIndWithAdolescentsAdd()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleIndWithAdolescentsAdd())#" />,                                <cfqueryparam value="#arguments.Agencies.getforeignLanguagePreferred()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getforeignLanguagePreferred())#" />                                )' />                <cfset result.Agencies = "No identity value returned" />				<cfreturn result />			</cfcatch>		</cftry>        <cfset result.success = true />        <cfset result.catch = "No errors found" />        <cfset result.query = '                    INSERT INTO agencies                        (                        name,                        address1,                        address2,                        city,                        state,                        zipCode,                        location,                        phone,                        fax,                        website,                        acceptUGJunior,                        acceptUGSenior,                        acceptFirstYear,                        acceptSecondYear,                        totalStudents,                        agencyPractice,                        servicesProvided,                        theoryBase,                        macroArea,                        clinicalArea,                        other,                        stipend,                        forProfit,                        clinical,                        foundation,                        macro,                        combined,                        health,                        metro,                        carLicense,                        foriegnLanguage,                        flexTime,                        handicapAccessible,                        faithBased,                        affiliationAgreement,                        fwsAgreement,                        agencyProfile,                        multipleSites,                        dateNinetyNine,                        datePhoneInformationReceived,                        dateOfAffiliation,                        dateOfVisit,                        backgroundDrugScreening,                        backgroundChildAbuse,                        backgroundImmunizationVerification,                        backgroundLiabilityVerification,                        backgroundSpecialApplication,                        backgroundReferenceLetters,                        backgroundFingerprinting,                        backgroundPoliceClearance,                        backgroundTBScreen,                        backgroundOther,                        backgroundRequiredDays,                        ageGroupAdults,                        ageGroupOlderAdults,                        ageGroupAdolescents,                        ageGroupFamilies,                        ageGroupChildren0to5,                        ageGroupChildren6to12,                        comments,                        needsLongForm,                        currentlyActive,                        doNotUse,                        agencyFlag,                        typeOfSetting,                        privateComments,                        leAdministration,                        leAdvocacy,                        leCaseManagement,                        leClinicalCaseManagement,                        leCommOrganization,                        leCrisisIntervention,                        leDischargePlanning,                        leFamilyTreatment,                        leGroupTreatment,                        leIndWithAdult,                        leIndWithChildren,                        leIndWithAdolescents,                        lePolicyAnalysis,                        leProgramPlanning,                        leProgramManagement,                        leResearch,                        leOther1,                        leOther2,                        tbCogBehavioral,                        tbCommTheory,                        tbCommDevelopment,                        tbContingency,                        tbCrisis,                        tbEcological,                        tbEmpowerment,                        tbExchange,                        tbFamilyTherapy,                        tbFeminist,                        tbPowerDependence,                        tbPsychodynamic,                        tbPsychosocial,                        tbSolution,                        tbSystems,                        tbTranspersonal,                        lobbying,                        nonProfit,                        agencyPublic,                        agencyPrivate,                        federal,                        stateCounty,                        communityBased,                        undergraduateJunior,                        ataother,                        adultsRank,                        olderAdultsRank,                        adolescentsRank,                        familiesRank,                        children0to5Rank,                        children6to12Rank,                        multiple,                        isPrivate,                        isPublic,                        completedDate,                        completedName,                        completedEmail,                        undergraduateSenior,                        transport,                        backgroundMedicalExam,                        tHomeVisits,                        tDriversLicense,                        tAutomobile,                        tAgencyVehicle,                        tOwnVehicle,                        tCovered,                        tOther,                        mpPolicyAnalysis,                        mpAdvocacy,                        mpCommOrganization,                        mpManagement,                        mpAdministration,                        mpPlanning,                        mpEvalResearch,                        comments2,                        notSureYet,                        flexHours,                        leIndWithAdultAdd,                        leIndWithChildrenAdd,                        leIndWithAdolescentsAdd,                        foreignLanguagePreferred                        )                    VALUES                        (                        <cfqueryparam value="#arguments.Agencies.getname()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getname())#" />,                        <cfqueryparam value="#arguments.Agencies.getaddress1()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getaddress1())#" />,                        <cfqueryparam value="#arguments.Agencies.getaddress2()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getaddress2())#" />,                        <cfqueryparam value="#arguments.Agencies.getcity()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getcity())#" />,                        <cfqueryparam value="#arguments.Agencies.getstate()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getstate())#" />,                        <cfqueryparam value="#arguments.Agencies.getzipCode()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getzipCode())#" />,                        <cfqueryparam value="#arguments.Agencies.getlocation()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getlocation())#" />,                        <cfqueryparam value="#arguments.Agencies.getphone()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getphone())#" />,                        <cfqueryparam value="#arguments.Agencies.getfax()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getfax())#" />,                        <cfqueryparam value="#arguments.Agencies.getwebsite()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getwebsite())#" />,                        <cfqueryparam value="#arguments.Agencies.getacceptUGJunior()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getacceptUGJunior())#" />,                        <cfqueryparam value="#arguments.Agencies.getacceptUGSenior()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getacceptUGSenior())#" />,                        <cfqueryparam value="#arguments.Agencies.getacceptFirstYear()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getacceptFirstYear())#" />,                        <cfqueryparam value="#arguments.Agencies.getacceptSecondYear()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getacceptSecondYear())#" />,                        <cfqueryparam value="#arguments.Agencies.gettotalStudents()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.gettotalStudents())#" />,                        <cfqueryparam value="#arguments.Agencies.getagencyPractice()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getagencyPractice())#" />,                        <cfqueryparam value="#arguments.Agencies.getservicesProvided()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getservicesProvided())#" />,                        <cfqueryparam value="#arguments.Agencies.gettheoryBase()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.gettheoryBase())#" />,                        <cfqueryparam value="#arguments.Agencies.getmacroArea()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getmacroArea())#" />,                        <cfqueryparam value="#arguments.Agencies.getclinicalArea()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getclinicalArea())#" />,                        <cfqueryparam value="#arguments.Agencies.getother()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getother())#" />,                        <cfqueryparam value="#arguments.Agencies.getstipend()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getstipend())#" />,                        <cfqueryparam value="#arguments.Agencies.getforProfit()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getforProfit())#" />,                        <cfqueryparam value="#arguments.Agencies.getclinical()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getclinical())#" />,                        <cfqueryparam value="#arguments.Agencies.getfoundation()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getfoundation())#" />,                        <cfqueryparam value="#arguments.Agencies.getmacro()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getmacro())#" />,                        <cfqueryparam value="#arguments.Agencies.getcombined()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getcombined())#" />,                        <cfqueryparam value="#arguments.Agencies.gethealth()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gethealth())#" />,                        <cfqueryparam value="#arguments.Agencies.getmetro()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getmetro())#" />,                        <cfqueryparam value="#arguments.Agencies.getcarLicense()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getcarLicense())#" />,                        <cfqueryparam value="#arguments.Agencies.getforiegnLanguage()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getforiegnLanguage())#" />,                        <cfqueryparam value="#arguments.Agencies.getflexTime()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getflexTime())#" />,                        <cfqueryparam value="#arguments.Agencies.gethandicapAccessible()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gethandicapAccessible())#" />,                        <cfqueryparam value="#arguments.Agencies.getfaithBased()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getfaithBased())#" />,                        <cfqueryparam value="#arguments.Agencies.getaffiliationAgreement()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getaffiliationAgreement())#" />,                        <cfqueryparam value="#arguments.Agencies.getfwsAgreement()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getfwsAgreement())#" />,                        <cfqueryparam value="#arguments.Agencies.getagencyProfile()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getagencyProfile())#" />,                        <cfqueryparam value="#arguments.Agencies.getmultipleSites()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getmultipleSites())#" />,                        <cfqueryparam value="#arguments.Agencies.getdateNinetyNine()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getdateNinetyNine())#" />,                        <cfqueryparam value="#arguments.Agencies.getdatePhoneInformationReceived()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getdatePhoneInformationReceived())#" />,                        <cfqueryparam value="#arguments.Agencies.getdateOfAffiliation()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getdateOfAffiliation())#" />,                        <cfqueryparam value="#arguments.Agencies.getdateOfVisit()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getdateOfVisit())#" />,                        <cfqueryparam value="#arguments.Agencies.getbackgroundDrugScreening()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundDrugScreening())#" />,                        <cfqueryparam value="#arguments.Agencies.getbackgroundChildAbuse()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundChildAbuse())#" />,                        <cfqueryparam value="#arguments.Agencies.getbackgroundImmunizationVerification()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundImmunizationVerification())#" />,                        <cfqueryparam value="#arguments.Agencies.getbackgroundLiabilityVerification()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundLiabilityVerification())#" />,                        <cfqueryparam value="#arguments.Agencies.getbackgroundSpecialApplication()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundSpecialApplication())#" />,                        <cfqueryparam value="#arguments.Agencies.getbackgroundReferenceLetters()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundReferenceLetters())#" />,                        <cfqueryparam value="#arguments.Agencies.getbackgroundFingerprinting()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundFingerprinting())#" />,                        <cfqueryparam value="#arguments.Agencies.getbackgroundPoliceClearance()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundPoliceClearance())#" />,                        <cfqueryparam value="#arguments.Agencies.getbackgroundTBScreen()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundTBScreen())#" />,                        <cfqueryparam value="#arguments.Agencies.getbackgroundOther()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getbackgroundOther())#" />,                        <cfqueryparam value="#arguments.Agencies.getbackgroundRequiredDays()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getbackgroundRequiredDays())#" />,                        <cfqueryparam value="#arguments.Agencies.getageGroupAdults()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupAdults())#" />,                        <cfqueryparam value="#arguments.Agencies.getageGroupOlderAdults()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupOlderAdults())#" />,                        <cfqueryparam value="#arguments.Agencies.getageGroupAdolescents()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupAdolescents())#" />,                        <cfqueryparam value="#arguments.Agencies.getageGroupFamilies()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupFamilies())#" />,                        <cfqueryparam value="#arguments.Agencies.getageGroupChildren0to5()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupChildren0to5())#" />,                        <cfqueryparam value="#arguments.Agencies.getageGroupChildren6to12()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupChildren6to12())#" />,                        <cfqueryparam value="#arguments.Agencies.getcomments()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getcomments())#" />,                        <cfqueryparam value="#arguments.Agencies.getneedsLongForm()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getneedsLongForm())#" />,                        <cfqueryparam value="#arguments.Agencies.getcurrentlyActive()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getcurrentlyActive())#" />,                        <cfqueryparam value="#arguments.Agencies.getdoNotUse()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getdoNotUse())#" />,                        <cfqueryparam value="#arguments.Agencies.getagencyFlag()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getagencyFlag())#" />,                        <cfqueryparam value="#arguments.Agencies.gettypeOfSetting()#" CFSQLType="cf_sql_char" null="#not len(arguments.Agencies.gettypeOfSetting())#" />,                        <cfqueryparam value="#arguments.Agencies.getprivateComments()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getprivateComments())#" />,                        <cfqueryparam value="#arguments.Agencies.getleAdministration()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleAdministration())#" />,                        <cfqueryparam value="#arguments.Agencies.getleAdvocacy()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleAdvocacy())#" />,                        <cfqueryparam value="#arguments.Agencies.getleCaseManagement()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleCaseManagement())#" />,                        <cfqueryparam value="#arguments.Agencies.getleClinicalCaseManagement()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleClinicalCaseManagement())#" />,                        <cfqueryparam value="#arguments.Agencies.getleCommOrganization()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleCommOrganization())#" />,                        <cfqueryparam value="#arguments.Agencies.getleCrisisIntervention()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleCrisisIntervention())#" />,                        <cfqueryparam value="#arguments.Agencies.getleDischargePlanning()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleDischargePlanning())#" />,                        <cfqueryparam value="#arguments.Agencies.getleFamilyTreatment()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleFamilyTreatment())#" />,                        <cfqueryparam value="#arguments.Agencies.getleGroupTreatment()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleGroupTreatment())#" />,                        <cfqueryparam value="#arguments.Agencies.getleIndWithAdult()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleIndWithAdult())#" />,                        <cfqueryparam value="#arguments.Agencies.getleIndWithChildren()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleIndWithChildren())#" />,                        <cfqueryparam value="#arguments.Agencies.getleIndWithAdolescents()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleIndWithAdolescents())#" />,                        <cfqueryparam value="#arguments.Agencies.getlePolicyAnalysis()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getlePolicyAnalysis())#" />,                        <cfqueryparam value="#arguments.Agencies.getleProgramPlanning()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleProgramPlanning())#" />,                        <cfqueryparam value="#arguments.Agencies.getleProgramManagement()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleProgramManagement())#" />,                        <cfqueryparam value="#arguments.Agencies.getleResearch()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleResearch())#" />,                        <cfqueryparam value="#arguments.Agencies.getleOther1()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleOther1())#" />,                        <cfqueryparam value="#arguments.Agencies.getleOther2()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleOther2())#" />,                        <cfqueryparam value="#arguments.Agencies.gettbCogBehavioral()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbCogBehavioral())#" />,                        <cfqueryparam value="#arguments.Agencies.gettbCommTheory()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbCommTheory())#" />,                        <cfqueryparam value="#arguments.Agencies.gettbCommDevelopment()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbCommDevelopment())#" />,                        <cfqueryparam value="#arguments.Agencies.gettbContingency()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbContingency())#" />,                        <cfqueryparam value="#arguments.Agencies.gettbCrisis()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbCrisis())#" />,                        <cfqueryparam value="#arguments.Agencies.gettbEcological()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbEcological())#" />,                        <cfqueryparam value="#arguments.Agencies.gettbEmpowerment()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbEmpowerment())#" />,                        <cfqueryparam value="#arguments.Agencies.gettbExchange()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbExchange())#" />,                        <cfqueryparam value="#arguments.Agencies.gettbFamilyTherapy()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbFamilyTherapy())#" />,                        <cfqueryparam value="#arguments.Agencies.gettbFeminist()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbFeminist())#" />,                        <cfqueryparam value="#arguments.Agencies.gettbPowerDependence()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbPowerDependence())#" />,                        <cfqueryparam value="#arguments.Agencies.gettbPsychodynamic()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbPsychodynamic())#" />,                        <cfqueryparam value="#arguments.Agencies.gettbPsychosocial()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbPsychosocial())#" />,                        <cfqueryparam value="#arguments.Agencies.gettbSolution()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbSolution())#" />,                        <cfqueryparam value="#arguments.Agencies.gettbSystems()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbSystems())#" />,                        <cfqueryparam value="#arguments.Agencies.gettbTranspersonal()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbTranspersonal())#" />,                        <cfqueryparam value="#arguments.Agencies.getlobbying()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getlobbying())#" />,                        <cfqueryparam value="#arguments.Agencies.getnonProfit()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getnonProfit())#" />,                        <cfqueryparam value="#arguments.Agencies.getagencyPublic()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getagencyPublic())#" />,                        <cfqueryparam value="#arguments.Agencies.getagencyPrivate()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getagencyPrivate())#" />,                        <cfqueryparam value="#arguments.Agencies.getfederal()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getfederal())#" />,                        <cfqueryparam value="#arguments.Agencies.getstateCounty()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getstateCounty())#" />,                        <cfqueryparam value="#arguments.Agencies.getcommunityBased()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getcommunityBased())#" />,                        <cfqueryparam value="#arguments.Agencies.getundergraduateJunior()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getundergraduateJunior())#" />,                        <cfqueryparam value="#arguments.Agencies.getataother()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getataother())#" />,                        <cfqueryparam value="#arguments.Agencies.getadultsRank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getadultsRank())#" />,                        <cfqueryparam value="#arguments.Agencies.getolderAdultsRank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getolderAdultsRank())#" />,                        <cfqueryparam value="#arguments.Agencies.getadolescentsRank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getadolescentsRank())#" />,                        <cfqueryparam value="#arguments.Agencies.getfamiliesRank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getfamiliesRank())#" />,                        <cfqueryparam value="#arguments.Agencies.getchildren0to5Rank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getchildren0to5Rank())#" />,                        <cfqueryparam value="#arguments.Agencies.getchildren6to12Rank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getchildren6to12Rank())#" />,                        <cfqueryparam value="#arguments.Agencies.getmultiple()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getmultiple())#" />,                        <cfqueryparam value="#arguments.Agencies.getisPrivate()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getisPrivate())#" />,                        <cfqueryparam value="#arguments.Agencies.getisPublic()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getisPublic())#" />,                        <cfqueryparam value="#arguments.Agencies.getcompletedDate()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getcompletedDate())#" />,                        <cfqueryparam value="#arguments.Agencies.getcompletedName()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getcompletedName())#" />,                        <cfqueryparam value="#arguments.Agencies.getcompletedEmail()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getcompletedEmail())#" />,                        <cfqueryparam value="#arguments.Agencies.getundergraduateSenior()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getundergraduateSenior())#" />,                        <cfqueryparam value="#arguments.Agencies.gettransport()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettransport())#" />,                        <cfqueryparam value="#arguments.Agencies.getbackgroundMedicalExam()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundMedicalExam())#" />,                        <cfqueryparam value="#arguments.Agencies.gettHomeVisits()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettHomeVisits())#" />,                        <cfqueryparam value="#arguments.Agencies.gettDriversLicense()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettDriversLicense())#" />,                        <cfqueryparam value="#arguments.Agencies.gettAutomobile()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettAutomobile())#" />,                        <cfqueryparam value="#arguments.Agencies.gettAgencyVehicle()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettAgencyVehicle())#" />,                        <cfqueryparam value="#arguments.Agencies.gettOwnVehicle()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettOwnVehicle())#" />,                        <cfqueryparam value="#arguments.Agencies.gettCovered()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettCovered())#" />,                        <cfqueryparam value="#arguments.Agencies.gettOther()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.gettOther())#" />,                        <cfqueryparam value="#arguments.Agencies.getmpPolicyAnalysis()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpPolicyAnalysis())#" />,                        <cfqueryparam value="#arguments.Agencies.getmpAdvocacy()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpAdvocacy())#" />,                        <cfqueryparam value="#arguments.Agencies.getmpCommOrganization()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpCommOrganization())#" />,                        <cfqueryparam value="#arguments.Agencies.getmpManagement()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpManagement())#" />,                        <cfqueryparam value="#arguments.Agencies.getmpAdministration()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpAdministration())#" />,                        <cfqueryparam value="#arguments.Agencies.getmpPlanning()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpPlanning())#" />,                        <cfqueryparam value="#arguments.Agencies.getmpEvalResearch()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpEvalResearch())#" />,                        <cfqueryparam value="#arguments.Agencies.getcomments2()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getcomments2())#" />,                        <cfqueryparam value="#arguments.Agencies.getnotSureYet()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getnotSureYet())#" />,                        <cfqueryparam value="#arguments.Agencies.getflexHours()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getflexHours())#" />,                        <cfqueryparam value="#arguments.Agencies.getleIndWithAdultAdd()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleIndWithAdultAdd())#" />,                        <cfqueryparam value="#arguments.Agencies.getleIndWithChildrenAdd()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleIndWithChildrenAdd())#" />,                        <cfqueryparam value="#arguments.Agencies.getleIndWithAdolescentsAdd()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleIndWithAdolescentsAdd())#" />,                        <cfqueryparam value="#arguments.Agencies.getforeignLanguagePreferred()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getforeignLanguagePreferred())#" />                        )' />                <cfset result.id = returnid.IDENTITYCOL />        		<cfreturn result />	</cffunction>	<cffunction name="read" access="public" output="false" returntype="void">		<cfargument name="Agencies" type="Agencies" required="true" />		<cfset var qRead = "" />		<cfset var strReturn = structNew() />		<cftry>			<cfquery name="qRead" datasource="#variables.dsn#">				SELECT					id,					name,					address1,					address2,					city,					state,					zipCode,					location,					phone,					fax,					website,					acceptUGJunior,					acceptUGSenior,					acceptFirstYear,					acceptSecondYear,					totalStudents,					agencyPractice,					servicesProvided,					theoryBase,					macroArea,					clinicalArea,					other,					stipend,					forProfit,					clinical,					foundation,					macro,					combined,					health,					metro,					carLicense,					foriegnLanguage,					flexTime,					handicapAccessible,					faithBased,					affiliationAgreement,					fwsAgreement,					agencyProfile,					multipleSites,					dateNinetyNine,					datePhoneInformationReceived,					dateOfAffiliation,					dateOfVisit,					backgroundDrugScreening,					backgroundChildAbuse,					backgroundImmunizationVerification,					backgroundLiabilityVerification,					backgroundSpecialApplication,					backgroundReferenceLetters,					backgroundFingerprinting,					backgroundPoliceClearance,					backgroundTBScreen,					backgroundOther,					backgroundRequiredDays,					ageGroupAdults,					ageGroupOlderAdults,					ageGroupAdolescents,					ageGroupFamilies,					ageGroupChildren0to5,					ageGroupChildren6to12,					comments,					needsLongForm,					currentlyActive,					doNotUse,					agencyFlag,					typeOfSetting,					privateComments,					leAdministration,					leAdvocacy,					leCaseManagement,					leClinicalCaseManagement,					leCommOrganization,					leCrisisIntervention,					leDischargePlanning,					leFamilyTreatment,					leGroupTreatment,					leIndWithAdult,					leIndWithChildren,					leIndWithAdolescents,					lePolicyAnalysis,					leProgramPlanning,					leProgramManagement,					leResearch,					leOther1,					leOther2,					tbCogBehavioral,					tbCommTheory,					tbCommDevelopment,					tbContingency,					tbCrisis,					tbEcological,					tbEmpowerment,					tbExchange,					tbFamilyTherapy,					tbFeminist,					tbPowerDependence,					tbPsychodynamic,					tbPsychosocial,					tbSolution,					tbSystems,					tbTranspersonal,					lobbying,					nonProfit,					agencyPublic,					agencyPrivate,					federal,					stateCounty,					communityBased,					undergraduateJunior,					ataother,					adultsRank,					olderAdultsRank,					adolescentsRank,					familiesRank,					children0to5Rank,					children6to12Rank,					multiple,					isPrivate,					isPublic,					completedDate,					completedName,					completedEmail,					undergraduateSenior,					transport,					backgroundMedicalExam,					tHomeVisits,					tDriversLicense,					tAutomobile,					tAgencyVehicle,					tOwnVehicle,					tCovered,					tOther,					mpPolicyAnalysis,					mpAdvocacy,					mpCommOrganization,					mpManagement,					mpAdministration,					mpPlanning,					mpEvalResearch,					comments2,					notSureYet,					flexHours,					leIndWithAdultAdd,					leIndWithChildrenAdd,					leIndWithAdolescentsAdd,					foreignLanguagePreferred				FROM	agencies				WHERE	id = <cfqueryparam value="#arguments.Agencies.getid()#" CFSQLType="cf_sql_integer" />			</cfquery>			<cfcatch type="database">				<!--- leave the bean as is and set an empty query for the conditional logic below --->				<cfset qRead = queryNew("id") />			</cfcatch>		</cftry>		<cfif qRead.recordCount>			<cfset strReturn = queryRowToStruct(qRead)>			<cfset arguments.Agencies.init(argumentCollection=strReturn)>		</cfif>	</cffunction>	<cffunction name="update" access="public" output="false" returntype="struct">		<cfargument name="Agencies" type="Agencies" required="true" />		<cfset var result = StructNew() />		<cfset var qUpdate = "" />		<cftry>			<cfquery name="qUpdate" datasource="#variables.dsn#">				UPDATE	agencies				SET					name = <cfqueryparam value="#arguments.Agencies.getname()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getname())#" />,					address1 = <cfqueryparam value="#arguments.Agencies.getaddress1()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getaddress1())#" />,					address2 = <cfqueryparam value="#arguments.Agencies.getaddress2()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getaddress2())#" />,					city = <cfqueryparam value="#arguments.Agencies.getcity()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getcity())#" />,					state = <cfqueryparam value="#arguments.Agencies.getstate()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getstate())#" />,					zipCode = <cfqueryparam value="#arguments.Agencies.getzipCode()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getzipCode())#" />,					location = <cfqueryparam value="#arguments.Agencies.getlocation()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getlocation())#" />,					phone = <cfqueryparam value="#arguments.Agencies.getphone()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getphone())#" />,					fax = <cfqueryparam value="#arguments.Agencies.getfax()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getfax())#" />,					website = <cfqueryparam value="#arguments.Agencies.getwebsite()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getwebsite())#" />,					acceptUGJunior = <cfqueryparam value="#arguments.Agencies.getacceptUGJunior()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getacceptUGJunior())#" />,					acceptUGSenior = <cfqueryparam value="#arguments.Agencies.getacceptUGSenior()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getacceptUGSenior())#" />,					acceptFirstYear = <cfqueryparam value="#arguments.Agencies.getacceptFirstYear()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getacceptFirstYear())#" />,					acceptSecondYear = <cfqueryparam value="#arguments.Agencies.getacceptSecondYear()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getacceptSecondYear())#" />,					totalStudents = <cfqueryparam value="#arguments.Agencies.gettotalStudents()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.gettotalStudents())#" />,					agencyPractice = <cfqueryparam value="#arguments.Agencies.getagencyPractice()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getagencyPractice())#" />,					servicesProvided = <cfqueryparam value="#arguments.Agencies.getservicesProvided()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getservicesProvided())#" />,					theoryBase = <cfqueryparam value="#arguments.Agencies.gettheoryBase()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.gettheoryBase())#" />,					macroArea = <cfqueryparam value="#arguments.Agencies.getmacroArea()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getmacroArea())#" />,					clinicalArea = <cfqueryparam value="#arguments.Agencies.getclinicalArea()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getclinicalArea())#" />,					other = <cfqueryparam value="#arguments.Agencies.getother()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getother())#" />,					stipend = <cfqueryparam value="#arguments.Agencies.getstipend()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getstipend())#" />,					forProfit = <cfqueryparam value="#arguments.Agencies.getforProfit()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getforProfit())#" />,					clinical = <cfqueryparam value="#arguments.Agencies.getclinical()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getclinical())#" />,					foundation = <cfqueryparam value="#arguments.Agencies.getfoundation()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getfoundation())#" />,					macro = <cfqueryparam value="#arguments.Agencies.getmacro()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getmacro())#" />,					combined = <cfqueryparam value="#arguments.Agencies.getcombined()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getcombined())#" />,					health = <cfqueryparam value="#arguments.Agencies.gethealth()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gethealth())#" />,					metro = <cfqueryparam value="#arguments.Agencies.getmetro()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getmetro())#" />,					carLicense = <cfqueryparam value="#arguments.Agencies.getcarLicense()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getcarLicense())#" />,					foriegnLanguage = <cfqueryparam value="#arguments.Agencies.getforiegnLanguage()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getforiegnLanguage())#" />,					flexTime = <cfqueryparam value="#arguments.Agencies.getflexTime()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getflexTime())#" />,					handicapAccessible = <cfqueryparam value="#arguments.Agencies.gethandicapAccessible()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gethandicapAccessible())#" />,					faithBased = <cfqueryparam value="#arguments.Agencies.getfaithBased()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getfaithBased())#" />,					affiliationAgreement = <cfqueryparam value="#arguments.Agencies.getaffiliationAgreement()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getaffiliationAgreement())#" />,					fwsAgreement = <cfqueryparam value="#arguments.Agencies.getfwsAgreement()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getfwsAgreement())#" />,					agencyProfile = <cfqueryparam value="#arguments.Agencies.getagencyProfile()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getagencyProfile())#" />,					multipleSites = <cfqueryparam value="#arguments.Agencies.getmultipleSites()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getmultipleSites())#" />,					dateNinetyNine = <cfqueryparam value="#arguments.Agencies.getdateNinetyNine()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getdateNinetyNine())#" />,					datePhoneInformationReceived = <cfqueryparam value="#arguments.Agencies.getdatePhoneInformationReceived()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getdatePhoneInformationReceived())#" />,					dateOfAffiliation = <cfqueryparam value="#arguments.Agencies.getdateOfAffiliation()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getdateOfAffiliation())#" />,					dateOfVisit = <cfqueryparam value="#arguments.Agencies.getdateOfVisit()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getdateOfVisit())#" />,					backgroundDrugScreening = <cfqueryparam value="#arguments.Agencies.getbackgroundDrugScreening()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundDrugScreening())#" />,					backgroundChildAbuse = <cfqueryparam value="#arguments.Agencies.getbackgroundChildAbuse()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundChildAbuse())#" />,					backgroundImmunizationVerification = <cfqueryparam value="#arguments.Agencies.getbackgroundImmunizationVerification()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundImmunizationVerification())#" />,					backgroundLiabilityVerification = <cfqueryparam value="#arguments.Agencies.getbackgroundLiabilityVerification()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundLiabilityVerification())#" />,					backgroundSpecialApplication = <cfqueryparam value="#arguments.Agencies.getbackgroundSpecialApplication()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundSpecialApplication())#" />,					backgroundReferenceLetters = <cfqueryparam value="#arguments.Agencies.getbackgroundReferenceLetters()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundReferenceLetters())#" />,					backgroundFingerprinting = <cfqueryparam value="#arguments.Agencies.getbackgroundFingerprinting()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundFingerprinting())#" />,					backgroundPoliceClearance = <cfqueryparam value="#arguments.Agencies.getbackgroundPoliceClearance()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundPoliceClearance())#" />,					backgroundTBScreen = <cfqueryparam value="#arguments.Agencies.getbackgroundTBScreen()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundTBScreen())#" />,					backgroundOther = <cfqueryparam value="#arguments.Agencies.getbackgroundOther()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getbackgroundOther())#" />,					backgroundRequiredDays = <cfqueryparam value="#arguments.Agencies.getbackgroundRequiredDays()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getbackgroundRequiredDays())#" />,					ageGroupAdults = <cfqueryparam value="#arguments.Agencies.getageGroupAdults()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupAdults())#" />,					ageGroupOlderAdults = <cfqueryparam value="#arguments.Agencies.getageGroupOlderAdults()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupOlderAdults())#" />,					ageGroupAdolescents = <cfqueryparam value="#arguments.Agencies.getageGroupAdolescents()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupAdolescents())#" />,					ageGroupFamilies = <cfqueryparam value="#arguments.Agencies.getageGroupFamilies()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupFamilies())#" />,					ageGroupChildren0to5 = <cfqueryparam value="#arguments.Agencies.getageGroupChildren0to5()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupChildren0to5())#" />,					ageGroupChildren6to12 = <cfqueryparam value="#arguments.Agencies.getageGroupChildren6to12()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupChildren6to12())#" />,					comments = <cfqueryparam value="#arguments.Agencies.getcomments()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getcomments())#" />,					needsLongForm = <cfqueryparam value="#arguments.Agencies.getneedsLongForm()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getneedsLongForm())#" />,					currentlyActive = <cfqueryparam value="#arguments.Agencies.getcurrentlyActive()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getcurrentlyActive())#" />,					doNotUse = <cfqueryparam value="#arguments.Agencies.getdoNotUse()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getdoNotUse())#" />,					agencyFlag = <cfqueryparam value="#arguments.Agencies.getagencyFlag()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getagencyFlag())#" />,					typeOfSetting = <cfqueryparam value="#arguments.Agencies.gettypeOfSetting()#" CFSQLType="cf_sql_char" null="#not len(arguments.Agencies.gettypeOfSetting())#" />,					privateComments = <cfqueryparam value="#arguments.Agencies.getprivateComments()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getprivateComments())#" />,					leAdministration = <cfqueryparam value="#arguments.Agencies.getleAdministration()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleAdministration())#" />,					leAdvocacy = <cfqueryparam value="#arguments.Agencies.getleAdvocacy()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleAdvocacy())#" />,					leCaseManagement = <cfqueryparam value="#arguments.Agencies.getleCaseManagement()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleCaseManagement())#" />,					leClinicalCaseManagement = <cfqueryparam value="#arguments.Agencies.getleClinicalCaseManagement()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleClinicalCaseManagement())#" />,					leCommOrganization = <cfqueryparam value="#arguments.Agencies.getleCommOrganization()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleCommOrganization())#" />,					leCrisisIntervention = <cfqueryparam value="#arguments.Agencies.getleCrisisIntervention()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleCrisisIntervention())#" />,					leDischargePlanning = <cfqueryparam value="#arguments.Agencies.getleDischargePlanning()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleDischargePlanning())#" />,					leFamilyTreatment = <cfqueryparam value="#arguments.Agencies.getleFamilyTreatment()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleFamilyTreatment())#" />,					leGroupTreatment = <cfqueryparam value="#arguments.Agencies.getleGroupTreatment()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleGroupTreatment())#" />,					leIndWithAdult = <cfqueryparam value="#arguments.Agencies.getleIndWithAdult()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleIndWithAdult())#" />,					leIndWithChildren = <cfqueryparam value="#arguments.Agencies.getleIndWithChildren()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleIndWithChildren())#" />,					leIndWithAdolescents = <cfqueryparam value="#arguments.Agencies.getleIndWithAdolescents()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleIndWithAdolescents())#" />,					lePolicyAnalysis = <cfqueryparam value="#arguments.Agencies.getlePolicyAnalysis()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getlePolicyAnalysis())#" />,					leProgramPlanning = <cfqueryparam value="#arguments.Agencies.getleProgramPlanning()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleProgramPlanning())#" />,					leProgramManagement = <cfqueryparam value="#arguments.Agencies.getleProgramManagement()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleProgramManagement())#" />,					leResearch = <cfqueryparam value="#arguments.Agencies.getleResearch()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleResearch())#" />,					leOther1 = <cfqueryparam value="#arguments.Agencies.getleOther1()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleOther1())#" />,					leOther2 = <cfqueryparam value="#arguments.Agencies.getleOther2()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleOther2())#" />,					tbCogBehavioral = <cfqueryparam value="#arguments.Agencies.gettbCogBehavioral()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbCogBehavioral())#" />,					tbCommTheory = <cfqueryparam value="#arguments.Agencies.gettbCommTheory()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbCommTheory())#" />,					tbCommDevelopment = <cfqueryparam value="#arguments.Agencies.gettbCommDevelopment()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbCommDevelopment())#" />,					tbContingency = <cfqueryparam value="#arguments.Agencies.gettbContingency()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbContingency())#" />,					tbCrisis = <cfqueryparam value="#arguments.Agencies.gettbCrisis()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbCrisis())#" />,					tbEcological = <cfqueryparam value="#arguments.Agencies.gettbEcological()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbEcological())#" />,					tbEmpowerment = <cfqueryparam value="#arguments.Agencies.gettbEmpowerment()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbEmpowerment())#" />,					tbExchange = <cfqueryparam value="#arguments.Agencies.gettbExchange()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbExchange())#" />,					tbFamilyTherapy = <cfqueryparam value="#arguments.Agencies.gettbFamilyTherapy()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbFamilyTherapy())#" />,					tbFeminist = <cfqueryparam value="#arguments.Agencies.gettbFeminist()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbFeminist())#" />,					tbPowerDependence = <cfqueryparam value="#arguments.Agencies.gettbPowerDependence()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbPowerDependence())#" />,					tbPsychodynamic = <cfqueryparam value="#arguments.Agencies.gettbPsychodynamic()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbPsychodynamic())#" />,					tbPsychosocial = <cfqueryparam value="#arguments.Agencies.gettbPsychosocial()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbPsychosocial())#" />,					tbSolution = <cfqueryparam value="#arguments.Agencies.gettbSolution()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbSolution())#" />,					tbSystems = <cfqueryparam value="#arguments.Agencies.gettbSystems()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbSystems())#" />,					tbTranspersonal = <cfqueryparam value="#arguments.Agencies.gettbTranspersonal()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbTranspersonal())#" />,					lobbying = <cfqueryparam value="#arguments.Agencies.getlobbying()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getlobbying())#" />,					nonProfit = <cfqueryparam value="#arguments.Agencies.getnonProfit()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getnonProfit())#" />,					agencyPublic = <cfqueryparam value="#arguments.Agencies.getagencyPublic()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getagencyPublic())#" />,					agencyPrivate = <cfqueryparam value="#arguments.Agencies.getagencyPrivate()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getagencyPrivate())#" />,					federal = <cfqueryparam value="#arguments.Agencies.getfederal()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getfederal())#" />,					stateCounty = <cfqueryparam value="#arguments.Agencies.getstateCounty()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getstateCounty())#" />,					communityBased = <cfqueryparam value="#arguments.Agencies.getcommunityBased()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getcommunityBased())#" />,					undergraduateJunior = <cfqueryparam value="#arguments.Agencies.getundergraduateJunior()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getundergraduateJunior())#" />,					ataother = <cfqueryparam value="#arguments.Agencies.getataother()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getataother())#" />,					adultsRank = <cfqueryparam value="#arguments.Agencies.getadultsRank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getadultsRank())#" />,					olderAdultsRank = <cfqueryparam value="#arguments.Agencies.getolderAdultsRank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getolderAdultsRank())#" />,					adolescentsRank = <cfqueryparam value="#arguments.Agencies.getadolescentsRank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getadolescentsRank())#" />,					familiesRank = <cfqueryparam value="#arguments.Agencies.getfamiliesRank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getfamiliesRank())#" />,					children0to5Rank = <cfqueryparam value="#arguments.Agencies.getchildren0to5Rank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getchildren0to5Rank())#" />,					children6to12Rank = <cfqueryparam value="#arguments.Agencies.getchildren6to12Rank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getchildren6to12Rank())#" />,					multiple = <cfqueryparam value="#arguments.Agencies.getmultiple()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getmultiple())#" />,					isPrivate = <cfqueryparam value="#arguments.Agencies.getisPrivate()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getisPrivate())#" />,					isPublic = <cfqueryparam value="#arguments.Agencies.getisPublic()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getisPublic())#" />,					completedDate = <cfqueryparam value="#arguments.Agencies.getcompletedDate()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getcompletedDate())#" />,					completedName = <cfqueryparam value="#arguments.Agencies.getcompletedName()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getcompletedName())#" />,					completedEmail = <cfqueryparam value="#arguments.Agencies.getcompletedEmail()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getcompletedEmail())#" />,					undergraduateSenior = <cfqueryparam value="#arguments.Agencies.getundergraduateSenior()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getundergraduateSenior())#" />,					transport = <cfqueryparam value="#arguments.Agencies.gettransport()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettransport())#" />,					backgroundMedicalExam = <cfqueryparam value="#arguments.Agencies.getbackgroundMedicalExam()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundMedicalExam())#" />,					tHomeVisits = <cfqueryparam value="#arguments.Agencies.gettHomeVisits()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettHomeVisits())#" />,					tDriversLicense = <cfqueryparam value="#arguments.Agencies.gettDriversLicense()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettDriversLicense())#" />,					tAutomobile = <cfqueryparam value="#arguments.Agencies.gettAutomobile()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettAutomobile())#" />,					tAgencyVehicle = <cfqueryparam value="#arguments.Agencies.gettAgencyVehicle()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettAgencyVehicle())#" />,					tOwnVehicle = <cfqueryparam value="#arguments.Agencies.gettOwnVehicle()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettOwnVehicle())#" />,					tCovered = <cfqueryparam value="#arguments.Agencies.gettCovered()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettCovered())#" />,					tOther = <cfqueryparam value="#arguments.Agencies.gettOther()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.gettOther())#" />,					mpPolicyAnalysis = <cfqueryparam value="#arguments.Agencies.getmpPolicyAnalysis()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpPolicyAnalysis())#" />,					mpAdvocacy = <cfqueryparam value="#arguments.Agencies.getmpAdvocacy()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpAdvocacy())#" />,					mpCommOrganization = <cfqueryparam value="#arguments.Agencies.getmpCommOrganization()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpCommOrganization())#" />,					mpManagement = <cfqueryparam value="#arguments.Agencies.getmpManagement()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpManagement())#" />,					mpAdministration = <cfqueryparam value="#arguments.Agencies.getmpAdministration()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpAdministration())#" />,					mpPlanning = <cfqueryparam value="#arguments.Agencies.getmpPlanning()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpPlanning())#" />,					mpEvalResearch = <cfqueryparam value="#arguments.Agencies.getmpEvalResearch()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpEvalResearch())#" />,					comments2 = <cfqueryparam value="#arguments.Agencies.getcomments2()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getcomments2())#" />,					notSureYet = <cfqueryparam value="#arguments.Agencies.getnotSureYet()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getnotSureYet())#" />,					flexHours = <cfqueryparam value="#arguments.Agencies.getflexHours()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getflexHours())#" />,					leIndWithAdultAdd = <cfqueryparam value="#arguments.Agencies.getleIndWithAdultAdd()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleIndWithAdultAdd())#" />,					leIndWithChildrenAdd = <cfqueryparam value="#arguments.Agencies.getleIndWithChildrenAdd()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleIndWithChildrenAdd())#" />,					leIndWithAdolescentsAdd = <cfqueryparam value="#arguments.Agencies.getleIndWithAdolescentsAdd()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleIndWithAdolescentsAdd())#" />,					foreignLanguagePreferred = <cfqueryparam value="#arguments.Agencies.getforeignLanguagePreferred()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getforeignLanguagePreferred())#" />				WHERE	id = <cfqueryparam value="#arguments.Agencies.getid()#" CFSQLType="cf_sql_integer" />			</cfquery>			<cfcatch type="database">            	<cfset result.success = false />                <cfset result.catch = cfcatch />            	<cfset result.query = '                UPDATE	agencies				SET					name = <cfqueryparam value="#arguments.Agencies.getname()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getname())#" />,					address1 = <cfqueryparam value="#arguments.Agencies.getaddress1()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getaddress1())#" />,					address2 = <cfqueryparam value="#arguments.Agencies.getaddress2()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getaddress2())#" />,					city = <cfqueryparam value="#arguments.Agencies.getcity()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getcity())#" />,					state = <cfqueryparam value="#arguments.Agencies.getstate()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getstate())#" />,					zipCode = <cfqueryparam value="#arguments.Agencies.getzipCode()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getzipCode())#" />,					location = <cfqueryparam value="#arguments.Agencies.getlocation()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getlocation())#" />,					phone = <cfqueryparam value="#arguments.Agencies.getphone()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getphone())#" />,					fax = <cfqueryparam value="#arguments.Agencies.getfax()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getfax())#" />,					website = <cfqueryparam value="#arguments.Agencies.getwebsite()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getwebsite())#" />,					acceptUGJunior = <cfqueryparam value="#arguments.Agencies.getacceptUGJunior()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getacceptUGJunior())#" />,					acceptUGSenior = <cfqueryparam value="#arguments.Agencies.getacceptUGSenior()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getacceptUGSenior())#" />,					acceptFirstYear = <cfqueryparam value="#arguments.Agencies.getacceptFirstYear()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getacceptFirstYear())#" />,					acceptSecondYear = <cfqueryparam value="#arguments.Agencies.getacceptSecondYear()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getacceptSecondYear())#" />,					totalStudents = <cfqueryparam value="#arguments.Agencies.gettotalStudents()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.gettotalStudents())#" />,					agencyPractice = <cfqueryparam value="#arguments.Agencies.getagencyPractice()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getagencyPractice())#" />,					servicesProvided = <cfqueryparam value="#arguments.Agencies.getservicesProvided()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getservicesProvided())#" />,					theoryBase = <cfqueryparam value="#arguments.Agencies.gettheoryBase()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.gettheoryBase())#" />,					macroArea = <cfqueryparam value="#arguments.Agencies.getmacroArea()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getmacroArea())#" />,					clinicalArea = <cfqueryparam value="#arguments.Agencies.getclinicalArea()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getclinicalArea())#" />,					other = <cfqueryparam value="#arguments.Agencies.getother()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getother())#" />,					stipend = <cfqueryparam value="#arguments.Agencies.getstipend()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getstipend())#" />,					forProfit = <cfqueryparam value="#arguments.Agencies.getforProfit()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getforProfit())#" />,					clinical = <cfqueryparam value="#arguments.Agencies.getclinical()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getclinical())#" />,					foundation = <cfqueryparam value="#arguments.Agencies.getfoundation()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getfoundation())#" />,					macro = <cfqueryparam value="#arguments.Agencies.getmacro()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getmacro())#" />,					combined = <cfqueryparam value="#arguments.Agencies.getcombined()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getcombined())#" />,					health = <cfqueryparam value="#arguments.Agencies.gethealth()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gethealth())#" />,					metro = <cfqueryparam value="#arguments.Agencies.getmetro()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getmetro())#" />,					carLicense = <cfqueryparam value="#arguments.Agencies.getcarLicense()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getcarLicense())#" />,					foriegnLanguage = <cfqueryparam value="#arguments.Agencies.getforiegnLanguage()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getforiegnLanguage())#" />,					flexTime = <cfqueryparam value="#arguments.Agencies.getflexTime()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getflexTime())#" />,					handicapAccessible = <cfqueryparam value="#arguments.Agencies.gethandicapAccessible()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gethandicapAccessible())#" />,					faithBased = <cfqueryparam value="#arguments.Agencies.getfaithBased()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getfaithBased())#" />,					affiliationAgreement = <cfqueryparam value="#arguments.Agencies.getaffiliationAgreement()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getaffiliationAgreement())#" />,					fwsAgreement = <cfqueryparam value="#arguments.Agencies.getfwsAgreement()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getfwsAgreement())#" />,					agencyProfile = <cfqueryparam value="#arguments.Agencies.getagencyProfile()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getagencyProfile())#" />,					multipleSites = <cfqueryparam value="#arguments.Agencies.getmultipleSites()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getmultipleSites())#" />,					dateNinetyNine = <cfqueryparam value="#arguments.Agencies.getdateNinetyNine()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getdateNinetyNine())#" />,					datePhoneInformationReceived = <cfqueryparam value="#arguments.Agencies.getdatePhoneInformationReceived()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getdatePhoneInformationReceived())#" />,					dateOfAffiliation = <cfqueryparam value="#arguments.Agencies.getdateOfAffiliation()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getdateOfAffiliation())#" />,					dateOfVisit = <cfqueryparam value="#arguments.Agencies.getdateOfVisit()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getdateOfVisit())#" />,					backgroundDrugScreening = <cfqueryparam value="#arguments.Agencies.getbackgroundDrugScreening()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundDrugScreening())#" />,					backgroundChildAbuse = <cfqueryparam value="#arguments.Agencies.getbackgroundChildAbuse()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundChildAbuse())#" />,					backgroundImmunizationVerification = <cfqueryparam value="#arguments.Agencies.getbackgroundImmunizationVerification()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundImmunizationVerification())#" />,					backgroundLiabilityVerification = <cfqueryparam value="#arguments.Agencies.getbackgroundLiabilityVerification()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundLiabilityVerification())#" />,					backgroundSpecialApplication = <cfqueryparam value="#arguments.Agencies.getbackgroundSpecialApplication()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundSpecialApplication())#" />,					backgroundReferenceLetters = <cfqueryparam value="#arguments.Agencies.getbackgroundReferenceLetters()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundReferenceLetters())#" />,					backgroundFingerprinting = <cfqueryparam value="#arguments.Agencies.getbackgroundFingerprinting()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundFingerprinting())#" />,					backgroundPoliceClearance = <cfqueryparam value="#arguments.Agencies.getbackgroundPoliceClearance()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundPoliceClearance())#" />,					backgroundTBScreen = <cfqueryparam value="#arguments.Agencies.getbackgroundTBScreen()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundTBScreen())#" />,					backgroundOther = <cfqueryparam value="#arguments.Agencies.getbackgroundOther()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getbackgroundOther())#" />,					backgroundRequiredDays = <cfqueryparam value="#arguments.Agencies.getbackgroundRequiredDays()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getbackgroundRequiredDays())#" />,					ageGroupAdults = <cfqueryparam value="#arguments.Agencies.getageGroupAdults()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupAdults())#" />,					ageGroupOlderAdults = <cfqueryparam value="#arguments.Agencies.getageGroupOlderAdults()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupOlderAdults())#" />,					ageGroupAdolescents = <cfqueryparam value="#arguments.Agencies.getageGroupAdolescents()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupAdolescents())#" />,					ageGroupFamilies = <cfqueryparam value="#arguments.Agencies.getageGroupFamilies()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupFamilies())#" />,					ageGroupChildren0to5 = <cfqueryparam value="#arguments.Agencies.getageGroupChildren0to5()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupChildren0to5())#" />,					ageGroupChildren6to12 = <cfqueryparam value="#arguments.Agencies.getageGroupChildren6to12()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupChildren6to12())#" />,					comments = <cfqueryparam value="#arguments.Agencies.getcomments()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getcomments())#" />,					needsLongForm = <cfqueryparam value="#arguments.Agencies.getneedsLongForm()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getneedsLongForm())#" />,					currentlyActive = <cfqueryparam value="#arguments.Agencies.getcurrentlyActive()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getcurrentlyActive())#" />,					doNotUse = <cfqueryparam value="#arguments.Agencies.getdoNotUse()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getdoNotUse())#" />,					agencyFlag = <cfqueryparam value="#arguments.Agencies.getagencyFlag()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getagencyFlag())#" />,					typeOfSetting = <cfqueryparam value="#arguments.Agencies.gettypeOfSetting()#" CFSQLType="cf_sql_char" null="#not len(arguments.Agencies.gettypeOfSetting())#" />,					privateComments = <cfqueryparam value="#arguments.Agencies.getprivateComments()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getprivateComments())#" />,					leAdministration = <cfqueryparam value="#arguments.Agencies.getleAdministration()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleAdministration())#" />,					leAdvocacy = <cfqueryparam value="#arguments.Agencies.getleAdvocacy()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleAdvocacy())#" />,					leCaseManagement = <cfqueryparam value="#arguments.Agencies.getleCaseManagement()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleCaseManagement())#" />,					leClinicalCaseManagement = <cfqueryparam value="#arguments.Agencies.getleClinicalCaseManagement()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleClinicalCaseManagement())#" />,					leCommOrganization = <cfqueryparam value="#arguments.Agencies.getleCommOrganization()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleCommOrganization())#" />,					leCrisisIntervention = <cfqueryparam value="#arguments.Agencies.getleCrisisIntervention()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleCrisisIntervention())#" />,					leDischargePlanning = <cfqueryparam value="#arguments.Agencies.getleDischargePlanning()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleDischargePlanning())#" />,					leFamilyTreatment = <cfqueryparam value="#arguments.Agencies.getleFamilyTreatment()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleFamilyTreatment())#" />,					leGroupTreatment = <cfqueryparam value="#arguments.Agencies.getleGroupTreatment()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleGroupTreatment())#" />,					leIndWithAdult = <cfqueryparam value="#arguments.Agencies.getleIndWithAdult()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleIndWithAdult())#" />,					leIndWithChildren = <cfqueryparam value="#arguments.Agencies.getleIndWithChildren()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleIndWithChildren())#" />,					leIndWithAdolescents = <cfqueryparam value="#arguments.Agencies.getleIndWithAdolescents()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleIndWithAdolescents())#" />,					lePolicyAnalysis = <cfqueryparam value="#arguments.Agencies.getlePolicyAnalysis()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getlePolicyAnalysis())#" />,					leProgramPlanning = <cfqueryparam value="#arguments.Agencies.getleProgramPlanning()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleProgramPlanning())#" />,					leProgramManagement = <cfqueryparam value="#arguments.Agencies.getleProgramManagement()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleProgramManagement())#" />,					leResearch = <cfqueryparam value="#arguments.Agencies.getleResearch()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleResearch())#" />,					leOther1 = <cfqueryparam value="#arguments.Agencies.getleOther1()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleOther1())#" />,					leOther2 = <cfqueryparam value="#arguments.Agencies.getleOther2()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleOther2())#" />,					tbCogBehavioral = <cfqueryparam value="#arguments.Agencies.gettbCogBehavioral()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbCogBehavioral())#" />,					tbCommTheory = <cfqueryparam value="#arguments.Agencies.gettbCommTheory()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbCommTheory())#" />,					tbCommDevelopment = <cfqueryparam value="#arguments.Agencies.gettbCommDevelopment()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbCommDevelopment())#" />,					tbContingency = <cfqueryparam value="#arguments.Agencies.gettbContingency()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbContingency())#" />,					tbCrisis = <cfqueryparam value="#arguments.Agencies.gettbCrisis()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbCrisis())#" />,					tbEcological = <cfqueryparam value="#arguments.Agencies.gettbEcological()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbEcological())#" />,					tbEmpowerment = <cfqueryparam value="#arguments.Agencies.gettbEmpowerment()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbEmpowerment())#" />,					tbExchange = <cfqueryparam value="#arguments.Agencies.gettbExchange()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbExchange())#" />,					tbFamilyTherapy = <cfqueryparam value="#arguments.Agencies.gettbFamilyTherapy()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbFamilyTherapy())#" />,					tbFeminist = <cfqueryparam value="#arguments.Agencies.gettbFeminist()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbFeminist())#" />,					tbPowerDependence = <cfqueryparam value="#arguments.Agencies.gettbPowerDependence()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbPowerDependence())#" />,					tbPsychodynamic = <cfqueryparam value="#arguments.Agencies.gettbPsychodynamic()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbPsychodynamic())#" />,					tbPsychosocial = <cfqueryparam value="#arguments.Agencies.gettbPsychosocial()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbPsychosocial())#" />,					tbSolution = <cfqueryparam value="#arguments.Agencies.gettbSolution()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbSolution())#" />,					tbSystems = <cfqueryparam value="#arguments.Agencies.gettbSystems()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbSystems())#" />,					tbTranspersonal = <cfqueryparam value="#arguments.Agencies.gettbTranspersonal()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbTranspersonal())#" />,					lobbying = <cfqueryparam value="#arguments.Agencies.getlobbying()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getlobbying())#" />,					nonProfit = <cfqueryparam value="#arguments.Agencies.getnonProfit()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getnonProfit())#" />,					agencyPublic = <cfqueryparam value="#arguments.Agencies.getagencyPublic()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getagencyPublic())#" />,					agencyPrivate = <cfqueryparam value="#arguments.Agencies.getagencyPrivate()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getagencyPrivate())#" />,					federal = <cfqueryparam value="#arguments.Agencies.getfederal()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getfederal())#" />,					stateCounty = <cfqueryparam value="#arguments.Agencies.getstateCounty()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getstateCounty())#" />,					communityBased = <cfqueryparam value="#arguments.Agencies.getcommunityBased()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getcommunityBased())#" />,					undergraduateJunior = <cfqueryparam value="#arguments.Agencies.getundergraduateJunior()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getundergraduateJunior())#" />,					ataother = <cfqueryparam value="#arguments.Agencies.getataother()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getataother())#" />,					adultsRank = <cfqueryparam value="#arguments.Agencies.getadultsRank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getadultsRank())#" />,					olderAdultsRank = <cfqueryparam value="#arguments.Agencies.getolderAdultsRank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getolderAdultsRank())#" />,					adolescentsRank = <cfqueryparam value="#arguments.Agencies.getadolescentsRank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getadolescentsRank())#" />,					familiesRank = <cfqueryparam value="#arguments.Agencies.getfamiliesRank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getfamiliesRank())#" />,					children0to5Rank = <cfqueryparam value="#arguments.Agencies.getchildren0to5Rank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getchildren0to5Rank())#" />,					children6to12Rank = <cfqueryparam value="#arguments.Agencies.getchildren6to12Rank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getchildren6to12Rank())#" />,					multiple = <cfqueryparam value="#arguments.Agencies.getmultiple()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getmultiple())#" />,					isPrivate = <cfqueryparam value="#arguments.Agencies.getisPrivate()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getisPrivate())#" />,					isPublic = <cfqueryparam value="#arguments.Agencies.getisPublic()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getisPublic())#" />,					completedDate = <cfqueryparam value="#arguments.Agencies.getcompletedDate()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getcompletedDate())#" />,					completedName = <cfqueryparam value="#arguments.Agencies.getcompletedName()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getcompletedName())#" />,					completedEmail = <cfqueryparam value="#arguments.Agencies.getcompletedEmail()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getcompletedEmail())#" />,					undergraduateSenior = <cfqueryparam value="#arguments.Agencies.getundergraduateSenior()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getundergraduateSenior())#" />,					transport = <cfqueryparam value="#arguments.Agencies.gettransport()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettransport())#" />,					backgroundMedicalExam = <cfqueryparam value="#arguments.Agencies.getbackgroundMedicalExam()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundMedicalExam())#" />,					tHomeVisits = <cfqueryparam value="#arguments.Agencies.gettHomeVisits()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettHomeVisits())#" />,					tDriversLicense = <cfqueryparam value="#arguments.Agencies.gettDriversLicense()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettDriversLicense())#" />,					tAutomobile = <cfqueryparam value="#arguments.Agencies.gettAutomobile()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettAutomobile())#" />,					tAgencyVehicle = <cfqueryparam value="#arguments.Agencies.gettAgencyVehicle()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettAgencyVehicle())#" />,					tOwnVehicle = <cfqueryparam value="#arguments.Agencies.gettOwnVehicle()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettOwnVehicle())#" />,					tCovered = <cfqueryparam value="#arguments.Agencies.gettCovered()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettCovered())#" />,					tOther = <cfqueryparam value="#arguments.Agencies.gettOther()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.gettOther())#" />,					mpPolicyAnalysis = <cfqueryparam value="#arguments.Agencies.getmpPolicyAnalysis()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpPolicyAnalysis())#" />,					mpAdvocacy = <cfqueryparam value="#arguments.Agencies.getmpAdvocacy()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpAdvocacy())#" />,					mpCommOrganization = <cfqueryparam value="#arguments.Agencies.getmpCommOrganization()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpCommOrganization())#" />,					mpManagement = <cfqueryparam value="#arguments.Agencies.getmpManagement()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpManagement())#" />,					mpAdministration = <cfqueryparam value="#arguments.Agencies.getmpAdministration()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpAdministration())#" />,					mpPlanning = <cfqueryparam value="#arguments.Agencies.getmpPlanning()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpPlanning())#" />,					mpEvalResearch = <cfqueryparam value="#arguments.Agencies.getmpEvalResearch()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpEvalResearch())#" />,					comments2 = <cfqueryparam value="#arguments.Agencies.getcomments2()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getcomments2())#" />,					notSureYet = <cfqueryparam value="#arguments.Agencies.getnotSureYet()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getnotSureYet())#" />,					flexHours = <cfqueryparam value="#arguments.Agencies.getflexHours()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getflexHours())#" />,					leIndWithAdultAdd = <cfqueryparam value="#arguments.Agencies.getleIndWithAdultAdd()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleIndWithAdultAdd())#" />,					leIndWithChildrenAdd = <cfqueryparam value="#arguments.Agencies.getleIndWithChildrenAdd()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleIndWithChildrenAdd())#" />,					leIndWithAdolescentsAdd = <cfqueryparam value="#arguments.Agencies.getleIndWithAdolescentsAdd()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleIndWithAdolescentsAdd())#" />,					foreignLanguagePreferred = <cfqueryparam value="#arguments.Agencies.getforeignLanguagePreferred()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getforeignLanguagePreferred())#" />				WHERE	id = <cfqueryparam value="#arguments.Agencies.getid()#" CFSQLType="cf_sql_integer" />' />                        		<cfset result.id = "#arguments.Agencies.getid()#" />				<cfreturn result />			</cfcatch>		</cftry>        <cfset result.success = true />        <cfset result.catch = "No errors found" />        <cfset result.query = '                UPDATE	agencies				SET					name = <cfqueryparam value="#arguments.Agencies.getname()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getname())#" />,					address1 = <cfqueryparam value="#arguments.Agencies.getaddress1()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getaddress1())#" />,					address2 = <cfqueryparam value="#arguments.Agencies.getaddress2()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getaddress2())#" />,					city = <cfqueryparam value="#arguments.Agencies.getcity()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getcity())#" />,					state = <cfqueryparam value="#arguments.Agencies.getstate()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getstate())#" />,					zipCode = <cfqueryparam value="#arguments.Agencies.getzipCode()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getzipCode())#" />,					location = <cfqueryparam value="#arguments.Agencies.getlocation()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getlocation())#" />,					phone = <cfqueryparam value="#arguments.Agencies.getphone()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getphone())#" />,					fax = <cfqueryparam value="#arguments.Agencies.getfax()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getfax())#" />,					website = <cfqueryparam value="#arguments.Agencies.getwebsite()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getwebsite())#" />,					acceptUGJunior = <cfqueryparam value="#arguments.Agencies.getacceptUGJunior()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getacceptUGJunior())#" />,					acceptUGSenior = <cfqueryparam value="#arguments.Agencies.getacceptUGSenior()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getacceptUGSenior())#" />,					acceptFirstYear = <cfqueryparam value="#arguments.Agencies.getacceptFirstYear()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getacceptFirstYear())#" />,					acceptSecondYear = <cfqueryparam value="#arguments.Agencies.getacceptSecondYear()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getacceptSecondYear())#" />,					totalStudents = <cfqueryparam value="#arguments.Agencies.gettotalStudents()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.gettotalStudents())#" />,					agencyPractice = <cfqueryparam value="#arguments.Agencies.getagencyPractice()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getagencyPractice())#" />,					servicesProvided = <cfqueryparam value="#arguments.Agencies.getservicesProvided()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getservicesProvided())#" />,					theoryBase = <cfqueryparam value="#arguments.Agencies.gettheoryBase()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.gettheoryBase())#" />,					macroArea = <cfqueryparam value="#arguments.Agencies.getmacroArea()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getmacroArea())#" />,					clinicalArea = <cfqueryparam value="#arguments.Agencies.getclinicalArea()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getclinicalArea())#" />,					other = <cfqueryparam value="#arguments.Agencies.getother()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getother())#" />,					stipend = <cfqueryparam value="#arguments.Agencies.getstipend()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getstipend())#" />,					forProfit = <cfqueryparam value="#arguments.Agencies.getforProfit()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getforProfit())#" />,					clinical = <cfqueryparam value="#arguments.Agencies.getclinical()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getclinical())#" />,					foundation = <cfqueryparam value="#arguments.Agencies.getfoundation()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getfoundation())#" />,					macro = <cfqueryparam value="#arguments.Agencies.getmacro()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getmacro())#" />,					combined = <cfqueryparam value="#arguments.Agencies.getcombined()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getcombined())#" />,					health = <cfqueryparam value="#arguments.Agencies.gethealth()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gethealth())#" />,					metro = <cfqueryparam value="#arguments.Agencies.getmetro()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getmetro())#" />,					carLicense = <cfqueryparam value="#arguments.Agencies.getcarLicense()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getcarLicense())#" />,					foriegnLanguage = <cfqueryparam value="#arguments.Agencies.getforiegnLanguage()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getforiegnLanguage())#" />,					flexTime = <cfqueryparam value="#arguments.Agencies.getflexTime()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getflexTime())#" />,					handicapAccessible = <cfqueryparam value="#arguments.Agencies.gethandicapAccessible()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gethandicapAccessible())#" />,					faithBased = <cfqueryparam value="#arguments.Agencies.getfaithBased()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getfaithBased())#" />,					affiliationAgreement = <cfqueryparam value="#arguments.Agencies.getaffiliationAgreement()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getaffiliationAgreement())#" />,					fwsAgreement = <cfqueryparam value="#arguments.Agencies.getfwsAgreement()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getfwsAgreement())#" />,					agencyProfile = <cfqueryparam value="#arguments.Agencies.getagencyProfile()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getagencyProfile())#" />,					multipleSites = <cfqueryparam value="#arguments.Agencies.getmultipleSites()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getmultipleSites())#" />,					dateNinetyNine = <cfqueryparam value="#arguments.Agencies.getdateNinetyNine()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getdateNinetyNine())#" />,					datePhoneInformationReceived = <cfqueryparam value="#arguments.Agencies.getdatePhoneInformationReceived()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getdatePhoneInformationReceived())#" />,					dateOfAffiliation = <cfqueryparam value="#arguments.Agencies.getdateOfAffiliation()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getdateOfAffiliation())#" />,					dateOfVisit = <cfqueryparam value="#arguments.Agencies.getdateOfVisit()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getdateOfVisit())#" />,					backgroundDrugScreening = <cfqueryparam value="#arguments.Agencies.getbackgroundDrugScreening()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundDrugScreening())#" />,					backgroundChildAbuse = <cfqueryparam value="#arguments.Agencies.getbackgroundChildAbuse()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundChildAbuse())#" />,					backgroundImmunizationVerification = <cfqueryparam value="#arguments.Agencies.getbackgroundImmunizationVerification()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundImmunizationVerification())#" />,					backgroundLiabilityVerification = <cfqueryparam value="#arguments.Agencies.getbackgroundLiabilityVerification()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundLiabilityVerification())#" />,					backgroundSpecialApplication = <cfqueryparam value="#arguments.Agencies.getbackgroundSpecialApplication()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundSpecialApplication())#" />,					backgroundReferenceLetters = <cfqueryparam value="#arguments.Agencies.getbackgroundReferenceLetters()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundReferenceLetters())#" />,					backgroundFingerprinting = <cfqueryparam value="#arguments.Agencies.getbackgroundFingerprinting()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundFingerprinting())#" />,					backgroundPoliceClearance = <cfqueryparam value="#arguments.Agencies.getbackgroundPoliceClearance()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundPoliceClearance())#" />,					backgroundTBScreen = <cfqueryparam value="#arguments.Agencies.getbackgroundTBScreen()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundTBScreen())#" />,					backgroundOther = <cfqueryparam value="#arguments.Agencies.getbackgroundOther()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getbackgroundOther())#" />,					backgroundRequiredDays = <cfqueryparam value="#arguments.Agencies.getbackgroundRequiredDays()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getbackgroundRequiredDays())#" />,					ageGroupAdults = <cfqueryparam value="#arguments.Agencies.getageGroupAdults()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupAdults())#" />,					ageGroupOlderAdults = <cfqueryparam value="#arguments.Agencies.getageGroupOlderAdults()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupOlderAdults())#" />,					ageGroupAdolescents = <cfqueryparam value="#arguments.Agencies.getageGroupAdolescents()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupAdolescents())#" />,					ageGroupFamilies = <cfqueryparam value="#arguments.Agencies.getageGroupFamilies()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupFamilies())#" />,					ageGroupChildren0to5 = <cfqueryparam value="#arguments.Agencies.getageGroupChildren0to5()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupChildren0to5())#" />,					ageGroupChildren6to12 = <cfqueryparam value="#arguments.Agencies.getageGroupChildren6to12()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getageGroupChildren6to12())#" />,					comments = <cfqueryparam value="#arguments.Agencies.getcomments()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getcomments())#" />,					needsLongForm = <cfqueryparam value="#arguments.Agencies.getneedsLongForm()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getneedsLongForm())#" />,					currentlyActive = <cfqueryparam value="#arguments.Agencies.getcurrentlyActive()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getcurrentlyActive())#" />,					doNotUse = <cfqueryparam value="#arguments.Agencies.getdoNotUse()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getdoNotUse())#" />,					agencyFlag = <cfqueryparam value="#arguments.Agencies.getagencyFlag()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getagencyFlag())#" />,					typeOfSetting = <cfqueryparam value="#arguments.Agencies.gettypeOfSetting()#" CFSQLType="cf_sql_char" null="#not len(arguments.Agencies.gettypeOfSetting())#" />,					privateComments = <cfqueryparam value="#arguments.Agencies.getprivateComments()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getprivateComments())#" />,					leAdministration = <cfqueryparam value="#arguments.Agencies.getleAdministration()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleAdministration())#" />,					leAdvocacy = <cfqueryparam value="#arguments.Agencies.getleAdvocacy()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleAdvocacy())#" />,					leCaseManagement = <cfqueryparam value="#arguments.Agencies.getleCaseManagement()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleCaseManagement())#" />,					leClinicalCaseManagement = <cfqueryparam value="#arguments.Agencies.getleClinicalCaseManagement()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleClinicalCaseManagement())#" />,					leCommOrganization = <cfqueryparam value="#arguments.Agencies.getleCommOrganization()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleCommOrganization())#" />,					leCrisisIntervention = <cfqueryparam value="#arguments.Agencies.getleCrisisIntervention()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleCrisisIntervention())#" />,					leDischargePlanning = <cfqueryparam value="#arguments.Agencies.getleDischargePlanning()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleDischargePlanning())#" />,					leFamilyTreatment = <cfqueryparam value="#arguments.Agencies.getleFamilyTreatment()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleFamilyTreatment())#" />,					leGroupTreatment = <cfqueryparam value="#arguments.Agencies.getleGroupTreatment()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleGroupTreatment())#" />,					leIndWithAdult = <cfqueryparam value="#arguments.Agencies.getleIndWithAdult()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleIndWithAdult())#" />,					leIndWithChildren = <cfqueryparam value="#arguments.Agencies.getleIndWithChildren()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleIndWithChildren())#" />,					leIndWithAdolescents = <cfqueryparam value="#arguments.Agencies.getleIndWithAdolescents()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleIndWithAdolescents())#" />,					lePolicyAnalysis = <cfqueryparam value="#arguments.Agencies.getlePolicyAnalysis()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getlePolicyAnalysis())#" />,					leProgramPlanning = <cfqueryparam value="#arguments.Agencies.getleProgramPlanning()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleProgramPlanning())#" />,					leProgramManagement = <cfqueryparam value="#arguments.Agencies.getleProgramManagement()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleProgramManagement())#" />,					leResearch = <cfqueryparam value="#arguments.Agencies.getleResearch()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getleResearch())#" />,					leOther1 = <cfqueryparam value="#arguments.Agencies.getleOther1()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleOther1())#" />,					leOther2 = <cfqueryparam value="#arguments.Agencies.getleOther2()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleOther2())#" />,					tbCogBehavioral = <cfqueryparam value="#arguments.Agencies.gettbCogBehavioral()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbCogBehavioral())#" />,					tbCommTheory = <cfqueryparam value="#arguments.Agencies.gettbCommTheory()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbCommTheory())#" />,					tbCommDevelopment = <cfqueryparam value="#arguments.Agencies.gettbCommDevelopment()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbCommDevelopment())#" />,					tbContingency = <cfqueryparam value="#arguments.Agencies.gettbContingency()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbContingency())#" />,					tbCrisis = <cfqueryparam value="#arguments.Agencies.gettbCrisis()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbCrisis())#" />,					tbEcological = <cfqueryparam value="#arguments.Agencies.gettbEcological()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbEcological())#" />,					tbEmpowerment = <cfqueryparam value="#arguments.Agencies.gettbEmpowerment()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbEmpowerment())#" />,					tbExchange = <cfqueryparam value="#arguments.Agencies.gettbExchange()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbExchange())#" />,					tbFamilyTherapy = <cfqueryparam value="#arguments.Agencies.gettbFamilyTherapy()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbFamilyTherapy())#" />,					tbFeminist = <cfqueryparam value="#arguments.Agencies.gettbFeminist()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbFeminist())#" />,					tbPowerDependence = <cfqueryparam value="#arguments.Agencies.gettbPowerDependence()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbPowerDependence())#" />,					tbPsychodynamic = <cfqueryparam value="#arguments.Agencies.gettbPsychodynamic()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbPsychodynamic())#" />,					tbPsychosocial = <cfqueryparam value="#arguments.Agencies.gettbPsychosocial()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbPsychosocial())#" />,					tbSolution = <cfqueryparam value="#arguments.Agencies.gettbSolution()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbSolution())#" />,					tbSystems = <cfqueryparam value="#arguments.Agencies.gettbSystems()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbSystems())#" />,					tbTranspersonal = <cfqueryparam value="#arguments.Agencies.gettbTranspersonal()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettbTranspersonal())#" />,					lobbying = <cfqueryparam value="#arguments.Agencies.getlobbying()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getlobbying())#" />,					nonProfit = <cfqueryparam value="#arguments.Agencies.getnonProfit()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getnonProfit())#" />,					agencyPublic = <cfqueryparam value="#arguments.Agencies.getagencyPublic()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getagencyPublic())#" />,					agencyPrivate = <cfqueryparam value="#arguments.Agencies.getagencyPrivate()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getagencyPrivate())#" />,					federal = <cfqueryparam value="#arguments.Agencies.getfederal()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getfederal())#" />,					stateCounty = <cfqueryparam value="#arguments.Agencies.getstateCounty()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getstateCounty())#" />,					communityBased = <cfqueryparam value="#arguments.Agencies.getcommunityBased()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getcommunityBased())#" />,					undergraduateJunior = <cfqueryparam value="#arguments.Agencies.getundergraduateJunior()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getundergraduateJunior())#" />,					ataother = <cfqueryparam value="#arguments.Agencies.getataother()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getataother())#" />,					adultsRank = <cfqueryparam value="#arguments.Agencies.getadultsRank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getadultsRank())#" />,					olderAdultsRank = <cfqueryparam value="#arguments.Agencies.getolderAdultsRank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getolderAdultsRank())#" />,					adolescentsRank = <cfqueryparam value="#arguments.Agencies.getadolescentsRank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getadolescentsRank())#" />,					familiesRank = <cfqueryparam value="#arguments.Agencies.getfamiliesRank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getfamiliesRank())#" />,					children0to5Rank = <cfqueryparam value="#arguments.Agencies.getchildren0to5Rank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getchildren0to5Rank())#" />,					children6to12Rank = <cfqueryparam value="#arguments.Agencies.getchildren6to12Rank()#" CFSQLType="cf_sql_integer" null="#not len(arguments.Agencies.getchildren6to12Rank())#" />,					multiple = <cfqueryparam value="#arguments.Agencies.getmultiple()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getmultiple())#" />,					isPrivate = <cfqueryparam value="#arguments.Agencies.getisPrivate()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getisPrivate())#" />,					isPublic = <cfqueryparam value="#arguments.Agencies.getisPublic()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getisPublic())#" />,					completedDate = <cfqueryparam value="#arguments.Agencies.getcompletedDate()#" CFSQLType="cf_sql_timestamp" null="#not len(arguments.Agencies.getcompletedDate())#" />,					completedName = <cfqueryparam value="#arguments.Agencies.getcompletedName()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getcompletedName())#" />,					completedEmail = <cfqueryparam value="#arguments.Agencies.getcompletedEmail()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getcompletedEmail())#" />,					undergraduateSenior = <cfqueryparam value="#arguments.Agencies.getundergraduateSenior()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getundergraduateSenior())#" />,					transport = <cfqueryparam value="#arguments.Agencies.gettransport()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettransport())#" />,					backgroundMedicalExam = <cfqueryparam value="#arguments.Agencies.getbackgroundMedicalExam()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getbackgroundMedicalExam())#" />,					tHomeVisits = <cfqueryparam value="#arguments.Agencies.gettHomeVisits()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettHomeVisits())#" />,					tDriversLicense = <cfqueryparam value="#arguments.Agencies.gettDriversLicense()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettDriversLicense())#" />,					tAutomobile = <cfqueryparam value="#arguments.Agencies.gettAutomobile()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettAutomobile())#" />,					tAgencyVehicle = <cfqueryparam value="#arguments.Agencies.gettAgencyVehicle()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettAgencyVehicle())#" />,					tOwnVehicle = <cfqueryparam value="#arguments.Agencies.gettOwnVehicle()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettOwnVehicle())#" />,					tCovered = <cfqueryparam value="#arguments.Agencies.gettCovered()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.gettCovered())#" />,					tOther = <cfqueryparam value="#arguments.Agencies.gettOther()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.gettOther())#" />,					mpPolicyAnalysis = <cfqueryparam value="#arguments.Agencies.getmpPolicyAnalysis()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpPolicyAnalysis())#" />,					mpAdvocacy = <cfqueryparam value="#arguments.Agencies.getmpAdvocacy()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpAdvocacy())#" />,					mpCommOrganization = <cfqueryparam value="#arguments.Agencies.getmpCommOrganization()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpCommOrganization())#" />,					mpManagement = <cfqueryparam value="#arguments.Agencies.getmpManagement()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpManagement())#" />,					mpAdministration = <cfqueryparam value="#arguments.Agencies.getmpAdministration()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpAdministration())#" />,					mpPlanning = <cfqueryparam value="#arguments.Agencies.getmpPlanning()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpPlanning())#" />,					mpEvalResearch = <cfqueryparam value="#arguments.Agencies.getmpEvalResearch()#" CFSQLType="cf_sql_tinyint" null="#not len(arguments.Agencies.getmpEvalResearch())#" />,					comments2 = <cfqueryparam value="#arguments.Agencies.getcomments2()#" CFSQLType="cf_sql_longvarchar" null="#not len(arguments.Agencies.getcomments2())#" />,					notSureYet = <cfqueryparam value="#arguments.Agencies.getnotSureYet()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getnotSureYet())#" />,					flexHours = <cfqueryparam value="#arguments.Agencies.getflexHours()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getflexHours())#" />,					leIndWithAdultAdd = <cfqueryparam value="#arguments.Agencies.getleIndWithAdultAdd()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleIndWithAdultAdd())#" />,					leIndWithChildrenAdd = <cfqueryparam value="#arguments.Agencies.getleIndWithChildrenAdd()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleIndWithChildrenAdd())#" />,					leIndWithAdolescentsAdd = <cfqueryparam value="#arguments.Agencies.getleIndWithAdolescentsAdd()#" CFSQLType="cf_sql_varchar" null="#not len(arguments.Agencies.getleIndWithAdolescentsAdd())#" />,					foreignLanguagePreferred = <cfqueryparam value="#arguments.Agencies.getforeignLanguagePreferred()#" CFSQLType="cf_sql_bit" null="#not len(arguments.Agencies.getforeignLanguagePreferred())#" />				WHERE	id = <cfqueryparam value="#arguments.Agencies.getid()#" CFSQLType="cf_sql_integer" />' />                <cfset result.id = "#arguments.Agencies.getid()#" />      		<cfreturn result />	</cffunction>	<cffunction name="delete" access="public" output="false" returntype="struct">		<cfargument name="Agencies" type="Agencies" required="true" />		        <cfset var result = structNew()>		<cfset var qDelete = "">		<cftry>			<cfquery name="qDelete" datasource="#variables.dsn#">				DELETE FROM	agencies 				WHERE	id = <cfqueryparam value="#arguments.Agencies.getid()#" CFSQLType="cf_sql_integer" />			</cfquery>			<cfcatch type="database">				<cfset result.success = false />                <cfset result.catch = cfcatch />            	<cfset result.query = '                DELETE FROM	agencies 				WHERE	id = <cfqueryparam value="#arguments.Agencies.getid()#" CFSQLType="cf_sql_integer" />' />                        		<cfset result.id = "#arguments.Agencies.getid()#" />                <cfreturn result />			</cfcatch>		</cftry>		<cfset result.success = true />        <cfset result.catch = "No errors found" />        <cfset result.query = '                DELETE FROM	agencies 				WHERE	id = <cfqueryparam value="#arguments.Agencies.getid()#" CFSQLType="cf_sql_integer" />' />                <cfset result.id = "#arguments.Agencies.getid()#" />        <cfreturn result />	</cffunction>	<cffunction name="exists" access="public" output="false" returntype="boolean">		<cfargument name="Agencies" type="Agencies" required="true" />		<cfset var qExists = "">		<cfquery name="qExists" datasource="#variables.dsn#" maxrows="1">			SELECT count(1) as idexists			FROM	agencies			WHERE	id = <cfqueryparam value="#arguments.Agencies.getid()#" CFSQLType="cf_sql_integer" />		</cfquery>		<cfif qExists.idexists>			<cfreturn true />		<cfelse>			<cfreturn false />		</cfif>	</cffunction>	<cffunction name="save" access="public" output="false" returntype="struct">		<cfargument name="Agencies" type="Agencies" required="true" />				<cfset var result = "" />		<cfif exists(arguments.Agencies)>			<cfset result = update(arguments.Agencies) />		<cfelse>			<cfset result = create(arguments.Agencies) />		</cfif>				<cfreturn result />	</cffunction>	<cffunction name="queryRowToStruct" access="private" output="false" returntype="struct">		<cfargument name="qry" type="query" required="true">				<cfscript>			/**			 * Makes a row of a query into a structure.			 * 			 * @param query 	 The query to work with. 			 * @param row 	 Row number to check. Defaults to row 1. 			 * @return Returns a structure. 			 * @author Nathan Dintenfass (nathan@changemedia.com) 			 * @version 1, December 11, 2001 			 */			//by default, do this to the first row of the query			var row = 1;			//a var for looping			var ii = 1;			//the cols to loop over			var cols = listToArray(qry.columnList);			//the struct to return			var stReturn = structnew();			//if there is a second argument, use that for the row number			if(arrayLen(arguments) GT 1)				row = arguments[2];			//loop over the cols and build the struct from the query row			for(ii = 1; ii lte arraylen(cols); ii = ii + 1){				stReturn[cols[ii]] = qry[cols[ii]][row];			}					//return the struct			return stReturn;		</cfscript>	</cffunction></cfcomponent>
